IN_KIT_REQ_LVW

(SQL View)
 Index Back

Inv Kit Request Language View


SELECT D.BUSINESS_UNIT , A.PRODUCT_ID , A.PROD_COMPONENT_ID , L.LANGUAGE_CD , L.DESCR FROM PS_PRODKIT_COMPS A , PS_PROD_ITEM B , PS_PROD_ITEM_LNG L , PS_BUS_UNIT_TBL_IN D , PS_SET_CNTRL_REC SCR1 , PS_SET_CNTRL_REC SCR2 WHERE A.SETID = SCR1.SETID AND SCR1.SETCNTRLVALUE = D.BUSINESS_UNIT AND SCR1.REC_GROUP_ID = 'FS_18' AND SCR1.RECNAME = 'PRODKIT_COMPS' AND B.SETID = SCR2.SETID AND SCR2.SETCNTRLVALUE = D.BUSINESS_UNIT AND SCR2.REC_GROUP_ID = 'FS_18' AND SCR2.RECNAME = 'PROD_ITEM' AND A.PROD_COMPONENT_ID = B.PRODUCT_ID AND %CurrentDateIn BETWEEN A.date_in_effect AND A.date_obsolete

# 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
3 PROD_COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL Product Component ID
4 LANGUAGE_CD Character(3) VARCHAR2(3) NOT NULL Language Code
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description