SF_TRC_USAG_VW

(SQL View)
 Index Back

Serial genealogy Usage View

08/26/2002 FRD

SELECT A.BUSINESS_UNIT , A.INV_ITEM_ID , 0 , 0 , A.SERIAL_ID , A.INV_LOT_ID , A.TRANSACTION_NBR , A.COMPONENT_ID , A.OP_SEQUENCE , A.MG_ORIG_COMP_ID , A.QTY_CODE , A.COMP_SERIAL_ID , A.COMP_LOT_ID , A.SF_TRAC_TRAN_TYPE , A.PRODUCTION_ID , D.PRDN_AREA_CODE , A.SCHED_QTY , A.CREATEDTTM , A.LAST_MAINT_DTTM , A.LAST_MAINT_OPRID , 0 , 'R' , C.LOT_CONTROL , C.SERIAL_CONTROL , C.SETID , A.SF_TRC_USAG_STATUS , C.DESCR , A.TRACE_USAGE , B.PEND_CONSUME_QTY , B.PEND_LOSS_QTY , B.NON_OWN_FLAG , C.CFG_CODE_OPT , C.CONSIGNED_FLAG , C.UNIT_MEASURE_STD , B.ISSUE_METHOD FROM PS_SF_PRDNID_HEADR D , PS_SF_TRC_USAG A , PS_SF_COMP_LIST B , PS_MASTER_ITEM_TBL C WHERE D.BUSINESS_UNIT = B.BUSINESS_UNIT AND D.PRODUCTION_ID = B.PRODUCTION_ID AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PRODUCTION_ID = A.PRODUCTION_ID AND B.COMPONENT_ID = A.COMPONENT_ID AND B.OP_SEQUENCE = A.OP_SEQUENCE AND B.MG_ORIG_COMP_ID = A.MG_ORIG_COMP_ID AND B.QTY_CODE = A.QTY_CODE AND D.INV_ITEM_ID = A.INV_ITEM_ID AND A.COMPONENT_ID = C.INV_ITEM_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 INV_ITEM_ID Character(18) VARCHAR2(18) NOT NULL Item ID
3 SEQ_NBR Number(15,0) DECIMAL(15) NOT NULL Sequence Number
4 ROW_COUNT Number(8,0) INTEGER NOT NULL Number to Purge
5 SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Default Value: INSTALLATION_IN.DFLT_SERIAL_ID

6 INV_LOT_ID Character(15) VARCHAR2(15) NOT NULL Lot ID

Default Value: INSTALLATION_IN.DFLT_INV_LOT_ID

7 TRANSACTION_NBR Number(15,0) DECIMAL(15) NOT NULL 08/02/99 NAS: Changed the size of this field from 10 to 15. Based on Jim Hillman's decision to make the field at a standard size.
8 COMPONENT_ID Character(18) VARCHAR2(18) NOT NULL 04/10/00 (Internet Architecture) SCC: Uppercase label Id.

Prompt Table: SF_TRC_COMP_VW1

9 OP_SEQUENCE Number(4,0) SMALLINT NOT NULL Operation Sequence

Prompt Table: SF_TRC_COMP_VW2

10 MG_ORIG_COMP_ID Character(18) VARCHAR2(18) NOT NULL original component ID

Prompt Table: SF_TRC_COMP_VW3

11 QTY_CODE Character(3) VARCHAR2(3) NOT NULL Per
ASY=Assembly
ORD=Order

Default Value: ASY

Prompt Table: SF_TRC_COMP_VW4

12 COMP_SERIAL_ID Character(20) VARCHAR2(20) NOT NULL Serial ID

Prompt Table: %EDITTABLE3

13 COMP_LOT_ID Character(15) VARCHAR2(15) NOT NULL Component Lot ID

Prompt Table: %EDITTABLE2

14 SF_TRAC_TRAN_TYPE Character(4) VARCHAR2(4) NOT NULL Trace Type
1000=Regular PID
1001=Rework PID
1002=TearDown Pid
1003=Production Schedule
15 PRODUCTION_ID Character(10) VARCHAR2(10) NOT NULL Production ID

Prompt Table: SF_PRDNID_HEADR

16 PRDN_AREA_CODE Character(10) VARCHAR2(10) NOT NULL Production Area
17 SCHED_QTY Number(12,4) DECIMAL(11,4) NOT NULL Component Scheduled Qty
18 CREATEDTTM DateTime(26) TIMESTAMP DateTime of Query Creation
19 LAST_MAINT_DTTM DateTime(26) TIMESTAMP A system generated value that reflects the date and time a transaction was last modified
20 LAST_MAINT_OPRID Character(30) VARCHAR2(30) NOT NULL Last Maintained By Operator ID
21 SF_QTY_PER Number(16,10) DECIMAL(15,10) NOT NULL 07/06/99 SCC CN# SF800-9.0: Added label Quantity
22 PROCESSED_FLG Character(1) VARCHAR2(1) NOT NULL Plan Processed Flag
C=Complete
E=Errors
N=Initialize
P=In Process
23 LOT_CONTROL Character(1) VARCHAR2(1) NOT NULL Lot Control
N=N
Y=Y
24 SERIAL_CONTROL Character(1) VARCHAR2(1) NOT NULL Serial Control
N=N
Y=Y
25 SETID Character(5) VARCHAR2(5) NOT NULL SetID
26 SF_TRC_USAG_STATUS Character(1) VARCHAR2(1) NOT NULL FRD
1=Associated
2=Disassoc
3=Torndown
4=Split
27 DESCR Character(30) VARCHAR2(30) NOT NULL Description
28 TRACE_USAGE Character(1) VARCHAR2(1) NOT NULL Trace Usage
0=None
1=Serial Trace
2=Lot Trace
29 PEND_CONSUME_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_CONSUME
30 PEND_LOSS_QTY Signed Number(13,4) DECIMAL(11,4) NOT NULL 10/12/99 SCC CN#SF800-9.0: Added label id TO_PEND_LOSS
31 NON_OWN_FLAG Character(1) VARCHAR2(1) NOT NULL 07/30/1998 WHS CN#ENH8.0: Created Translate Values 'Y'es and 'N'o
N=No
Y=Yes
32 CFG_CODE_OPT Character(1) VARCHAR2(1) NOT NULL Configuration Code Generation
B=Both
N=No
Y=Yes
33 CONSIGNED_FLAG Character(1) VARCHAR2(1) NOT NULL Consigned Flag
34 UNIT_MEASURE_STD Character(3) VARCHAR2(3) NOT NULL Standard Unit of Measure
35 ISSUE_METHOD Character(4) VARCHAR2(4) NOT NULL Component Issue Method
COM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish