PTLT_PROD_VW2

index back

Valid Product Definitions

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

  • Related language record: PTLT_PRODLVW2
  • PeopleSoft Field Name Field Type Column Type Description
    PTLT_PRODUCT_CODE Character(4) VARCHAR2(4) NOT NULL Unique code for a product.
    PTLT_PRODUCT Character(30) VARCHAR2(30) NOT NULL Name of a product
    PTLT_INSTALL_FLD Character(18) VARCHAR2(18) NOT NULL Installation table fieldname

    Prompt Table: PTLT_INSTFLD_VW

    index back (c)David Kurtz 2019, www.go-faster.co.uk PeopleTools 8.54
    PTRef generated on 09-JUN-19