PTLT_PRODLVW2

index back

Valid Product Definitions

Show producst listed in the INSTALLATION record only.
SELECT A.PTLT_PRODUCT_CODE , A.LANGUAGE_CD , A.PTLT_PRODUCT , A1.PTLT_INSTALL_FLD FROM %Table(PTLT_PROD_LANG) A , %Table(PTLT_PRODUCT) A1 , %Table(PTLT_INSTFLD_VW) B WHERE A.PTLT_PRODUCT_CODE = A1.PTLT_PRODUCT_CODE AND A1.PTLT_INSTALL_FLD = B.FIELDNAME

  • Related language record for PTLT_PROD_VW2
  • PeopleSoft Field NameField TypeColumn TypeDescription
    PTLT_PRODUCT_CODECharacter(4)VARCHAR2(4) NOT NULLUnique code for a product.
    LANGUAGE_CDCharacter(3)VARCHAR2(3) NOT NULLLanguage Code translate values
    PTLT_PRODUCTCharacter(30)VARCHAR2(30) NOT NULLName of a product
    PTLT_INSTALL_FLDCharacter(18)VARCHAR2(18) NOT NULLInstallation table fieldname
    index back(c)David Kurtz 2019, www.go-faster.co.ukPeopleTools 8.54
    PTRef generated on 09-JUN-19