IN_LNG_PKTEX_VW

(SQL View)
 Index Back

Product Marked as Kit View

View of standard product kits. Configured product kits are excluded.

SELECT DISTINCT %Substring(A.SETCNTRLVALUE, 1, 5) , B.PRODUCT_ID , L.LANGUAGE_CD , L.DESCR , L.DESCR254 FROM PS_SET_CNTRL_REC A , PS_PROD_ITEM B , PS_IN_KIT_EXPL_OUT E , PS_PROD_ITEM_LNG L WHERE A.RECNAME = 'PROD_ITEM' AND A.SETID = B.SETID AND B.PRODUCT_KIT_FLAG = 'Y' AND B.CFG_KIT_FLAG = 'N' AND E.BUSINESS_UNIT = A.SETCNTRLVALUE AND E.PARENT_PROD_ID = B.PRODUCT_ID AND %Join(COMMON_KEYS, PROD_ITEM B, PROD_ITEM_LNG L)

  • Related Language Record for IN_FUL_PKTEX_VW

  • Parent record: PROD_ITEM

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID

    Prompt Table: PROD_KIT_VW

    3 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    4 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    5 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254