PTLT_PROJPRODVW

Platform

View Text

Default

SELECT DISTINCT A.PTLT_PROJ_NAME , B.PTLT_TASK_SEQNO , A.DESCR50 , B.PTLT_TASK_NAME , B.DESCR254_MIXED , E.PTLT_PRODUCT_CODE , E.PTLT_PRODUCT FROM %Table(PTLT_PROJ_DEFN) A , %Table(PTLT_PROJ_TASK) B , %Table(PTLT_ASSGN_TASK) C , %Table(PTLT_ASSGN_FEAT) D , %Table(PTLT_PRODUCT) E WHERE A.PTLT_PROJ_NAME = B.PTLT_PROJ_NAME AND B.PTLT_TASK_CODE = C.PTLT_TASK_CODE AND C.PTLT_FEATURE_CODE = D.PTLT_FEATURE_CODE AND D.PTLT_PRODUCT_CODE = E.PTLT_PRODUCT_CODE

PeopleSoft Field Name	Description
PTLT_PROJ_NAME	Used in Setup Manager v2.0 for Implementation Project Name.
PTLT_TASK_SEQNO	Task ID
DESCR50	Description of length 50
PTLT_TASK_NAME	Task Name
DESCR254_MIXED	Description
PTLT_PRODUCT_CODE	Unique code for a product.
PTLT_PRODUCT	Name of a product

Author: PeopleTools
Return to Index	© Go-Faster Consultancy Ltd.  Last updated 24 July 2010