PTLT_PRODLVW2

(SQL View)
 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 Name PeopleSoft Field Type Database Column Type Description
    1 PTLT_PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Unique code for a product.
    2 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    3 PTLT_PRODUCT Character(30) VARCHAR2(30) NOT NULL Name of a product
    4 PTLT_INSTALL_FLD Character(18) VARCHAR2(18) NOT NULL Installation table fieldname