PTLT_PRODFLTRVW

index back

Project Product View


SELECT DISTINCT A.PTLT_PROJ_NAME , 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

  • Related language record: PTLT_PRODFL_LVW
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTLT_PROJ_NAMECharacter(15)VARCHAR2(15) NOT NULLUsed in Setup Manager v2.0 for Implementation Project Name.
    PTLT_PRODUCT_CODECharacter(4)VARCHAR2(4) NOT NULLUnique code for a product.
    PTLT_PRODUCTCharacter(30)VARCHAR2(30) NOT NULLName of a product
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19