IN_KIT_REQ_VW

(SQL View)
 Index Back

Inventory Kit Request View


SELECT D.BUSINESS_UNIT , A.PRODUCT_ID , A.PROD_COMPONENT_ID , B.DESCR , A.QTY_PER , A.QTY_CODE , A.UNIT_OF_MEASURE , A.OPTIONAL_SHIP , A.MIN_QTY_PER , A.MAX_QTY_PER , B.INV_ITEM_ID , C.DESCR60 , A.SEQ_NUM FROM PS_PRODKIT_COMPS A , PS_PROD_ITEM B , PS_MASTER_ITEM_TBL C , PS_BUS_UNIT_TBL_IN D , PS_SET_CNTRL_REC SCR1 , PS_SET_CNTRL_REC SCR2 , PS_SET_CNTRL_REC SCR3 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 C.SETID = SCR3.SETID AND SCR3.SETCNTRLVALUE = D.BUSINESS_UNIT AND SCR3.REC_GROUP_ID = 'FS_18' AND SCR3.RECNAME = 'MASTER_ITEM_TBL' AND A.PROD_COMPONENT_ID = B.PRODUCT_ID AND C.INV_ITEM_ID = B.INV_ITEM_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 DESCR Character(30) VARCHAR2(30) NOT NULL Description
5 QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Quantity
6 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
7 UNIT_OF_MEASURE Character(3) VARCHAR2(3) NOT NULL Used on an approval rule set.
MHR=Muti Hourly
PER=Percentage
SQF=Square Footage
8 OPTIONAL_SHIP Character(1) VARCHAR2(1) NOT NULL OK to Ship Without

Y/N Table Edit

9 MIN_QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Minimum allowable quantity for a kit component
10 MAX_QTY_PER Number(10,4) DECIMAL(9,4) NOT NULL Maximum allowable quantity for a kit component
11 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
12 DESCR60 Character(60) VARCHAR2(60) NOT NULL Description
13 KIT_LINE_NBR Number(3,0) SMALLINT NOT NULL Kit Line Number