SF_CQTYREVS1_VW

(SQL View)
 Index Back

Physical Lot View/Comp


SELECT A.BUSINESS_UNIT , B.PRDN_AREA_CODE , B.INV_ITEM_ID , B.REVISION , B.BOM_CODE , B.RTG_CODE , A.COMPONENT_ID , A.OP_SEQUENCE , A.MG_ORIG_COMP_ID , A.QTY_CODE , A.INV_LOT_ID , A.SERIAL_ID , A.QTY_BASE FROM PS_SF_COMP_QTY A , PS_SF_PRDNID_HEADR B , PS_EN_REVISION C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND B.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND B.INV_ITEM_ID = C.INV_ITEM_ID AND A.QTY_BASE > 0 AND B.MA_PRDN_ID_FLG = 'N' AND (B.REVISION = C.REVISION OR (B.REVISION = ' ' AND EXISTS ( SELECT 'X' FROM PS_EN_REVISION D WHERE D.BUSINESS_UNIT = C.BUSINESS_UNIT AND D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.INV_ITEM_ID = C.INV_ITEM_ID AND D.REVISION = C.REVISION AND B.PRDN_DUE_DATE BETWEEN D.DATE_IN_EFFECT AND D.DATE_OBSOLETE)))

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
3 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
4 REVISION Character(4) VARCHAR2(4) NOT NULL 01/27/2000 RML Added "As of" label
5 BOM_CODE Number(2,0) SMALLINT NOT NULL CN# EN800-3.0, anna 09/21 added new field to database
6 RTG_CODE Number(2,0) SMALLINT NOT NULL Routing Code
7 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.
8 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence
9 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID
10 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order
11 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID
12 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID
13 QTY_BASE Signed Number(17,4) DECIMAL(15,4) NOT NULL Base Quantity