BUSINESS_UNITPRODUCTION_IDOP_SEQUENCECOM=Use Comp.
ISS=Issue
KIT=Kit
REPL=Replenish
ASY=Assembly
ORD=Order
SF_SUB_OP_VW(SQL View) |
Index Back |
|---|---|
Subcontracted Operations View12/01/05 EGS: Created |
| SELECT SPH.BUSINESS_UNIT , SPH.PRODUCTION_ID , SOL.OP_SEQUENCE , SPH.PRDN_AREA_CODE , SPH.INV_ITEM_ID , MIT.DESCR , SPH.NEW_PRDN_QTY , SPH.NEW_UOM , SOL.SUB_ITEM_ID , SCL.COMPONENT_ID , MIT3.UNIT_MEASURE_STD , MIT3.DESCR , SOL.OP_START_DT , SCL.CURR_SCHED_QTY , SCL.ISSUE_METHOD , SCL.QTY_CODE , SCL.SF_QTY_PER , SCL.YIELD , SOL.VENDOR_ID FROM PS_SF_PRDNID_HEADR SPH , PS_SF_OP_LIST SOL , PS_SF_COMP_LIST SCL , PS_SET_CNTRL_REC SCR , PS_MASTER_ITEM_TBL MIT , PS_MASTER_ITEM_TBL MIT3 WHERE SOL.BUSINESS_UNIT = SPH.BUSINESS_UNIT AND SOL.PRODUCTION_ID = SPH.PRODUCTION_ID AND SOL.SUBCONTRACTED = 'Y' AND SCL.BUSINESS_UNIT = SPH.BUSINESS_UNIT AND SCL.PRODUCTION_ID = SPH.PRODUCTION_ID AND SCL.OP_SEQUENCE = SOL.OP_SEQUENCE AND SCR.SETCNTRLVALUE = SPH.BUSINESS_UNIT AND SCR.RECNAME = 'MASTER_ITEM_TBL' AND MIT.SETID = SCR.SETID AND MIT.INV_ITEM_ID = SPH.INV_ITEM_ID AND MIT3.SETID = SCR.SETID AND MIT3.INV_ITEM_ID = SCL.COMPONENT_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 3 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 5 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 6 | DESCR | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 7 | NEW_PRDN_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | Production Start Qty |
| 8 | NEW_UOM | Character(3) | VARCHAR2(3) NOT NULL | Unit of Measure |
| 9 | SUB_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | 11/02/05 EGS: Created |
| 10 | COMPONENT_ID | Character(18) | VARCHAR2(18) NOT NULL | 04/10/00 (Internet Architecture) SCC: Uppercase label Id. |
| 11 | UNIT_MEASURE_STD | Character(3) | VARCHAR2(3) NOT NULL | Standard Unit of Measure |
| 12 | DESCR_2 | Character(30) | VARCHAR2(30) NOT NULL | Description |
| 13 | OP_START_DT | Date(10) | DATE | Operation Start Date |
| 14 | CURR_SCHED_QTY | Number(12,4) | DECIMAL(11,4) NOT NULL | 07/28/99 SCC CN#SF800-9.0: Added label id TO_CURR_SCHED |
| 15 | ISSUE_METHOD | Character(4) | VARCHAR2(4) NOT NULL |
Component Issue Method
COM=Use Comp. ISS=Issue KIT=Kit REPL=Replenish |
| 16 | QTY_CODE | Character(3) | VARCHAR2(3) NOT NULL |
Per
ASY=Assembly ORD=Order |
| 17 | SF_QTY_PER | Number(16,10) | DECIMAL(15,10) NOT NULL | 07/06/99 SCC CN# SF800-9.0: Added label Quantity |
| 18 | YIELD | Number(8,4) | DECIMAL(7,4) NOT NULL | Component Yield |
| 19 | VENDOR_ID | Character(10) | VARCHAR2(10) NOT NULL | Vendor Identifier |