ORDENT_PKIT_LVW

(SQL View)
 Index Back

Product Kit Comp Inv View


SELECT DISTINCT I.SOURCE_BUS_UNIT , I.ORDER_NO , I.ORDER_INT_LINE_NO , I.SCHED_LINE_NBR , I.PARENT_PROD_ID , I.PRODUCT_ID , P.LANGUAGE_CD , ' ' FROM PS_IN_DEMAND I , PS_SET_CNTRL_REC SC , PS_PRODKIT_COMPS PK , PS_MASTER_ITEM_TBL M , PS_PROD_ITEM_LNG P WHERE SC.SETCNTRLVALUE = I.SOURCE_BUS_UNIT AND SC.RECNAME = 'PROD_ITEM' AND I.PARENT_PROD_ID > ' ' AND PK.SETID = SC.SETID AND PK.PRODUCT_ID = I.PARENT_PROD_ID AND PK.PROD_COMPONENT_ID = I.PRODUCT_ID AND M.SETID = PK.SETID AND M.INV_ITEM_ID = I.ORIG_INV_ITEM_ID AND P.SETID = PK.SETID AND P.PRODUCT_ID = PK.PROD_COMPONENT_ID

  • Related Language Record for ORDENT_PKIT_VW

    • # PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
    1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
    2 ORDER_NO Character(10) VARCHAR2(10) NOT NULL Identifies a customer order number that appears as a reference on a receivables pending item. Date Initials Issue Description 022701 mv SP2 (F-CJORGENS-3) CSR Desktop
    3 ORDER_INT_LINE_NO Number(5,0) INTEGER NOT NULL Order Line
    4 SCHED_LINE_NBR Number(6,0) INTEGER NOT NULL Schedule Line Number
    5 PRODUCT_ID Character(18) VARCHAR2(18) NOT NULL Product ID
    6 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID
    7 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
    8 DESCR Character(30) VARCHAR2(30) NOT NULL Description