IN_PEG_PRKT_VW

(SQL View)
 Index Back

Product Marked as Kit View

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

SELECT %Substring(A.SETCNTRLVALUE, 1, 5) , B.PRODUCT_ID , B.DESCR , B.DESCR254 FROM PS_SET_CNTRL_REC A , PS_PROD_ITEM B WHERE A.REC_GROUP_ID = 'FS_18' AND A.RECNAME = 'PROD_ITEM' AND A.SETID = B.SETID AND B.PRODUCT_KIT_FLAG = 'Y' AND B.CFG_KIT_FLAG = 'N'

  • Related Language Record: IN_PEG_PRKTL_VW

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

    Prompt Table: PROD_KIT_VW

    3 DESCR Character(30) VARCHAR2(30) NOT NULL Description
    4 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254