CE_SCRAP_VW(SQL View) |
Index Back |
|---|---|
Scrap View |
| SELECT A.BUSINESS_UNIT , A.CM_BOOK , A.COST_ELEMENT , A.CURRENCY_CD , A.PRODUCTION_ID , B.INV_ITEM_ID , B.SCRAP_QTY , B.ORIG_UOM , B.PRDN_AREA_CODE , B.PRODUCTION_TYPE , B.LAST_DTTM_UPDATE , C.OP_SEQUENCE , SUM(A.CE_EXTENDED_COST) FROM PS_CE_ACTUAL_COST A , PS_SF_PRDNID_HEADR B , PS_SF_OP_HIST C WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND B.PROD_STATUS IN ('90', '70') AND b.scrap_qty > 0 AND B.COMPLETED_QTY = 0 AND C.OP_SEQUENCE = ( SELECT MAX(OP_SEQUENCE) FROM PS_SF_OP_HIST CC WHERE %Join(COMMON_KEYS, SF_PRDNID_HEADR A, SF_OP_HIST CC)) AND %Join(COMMON_KEYS, SF_PRDNID_HEADR A, SF_OP_HIST C) GROUP BY A.BUSINESS_UNIT, A.CM_BOOK, A.COST_ELEMENT, A.PRODUCTION_ID, B.INV_ITEM_ID, B.SCRAP_QTY, B.ORIG_UOM, A.CURRENCY_CD, B.PRDN_AREA_CODE, B.PRODUCTION_TYPE, B.LAST_DTTM_UPDATE, C.OP_SEQUENCE |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CM_BOOK | Character(10) | VARCHAR2(10) NOT NULL | Cost Book |
| 3 | COST_ELEMENT | Character(4) | VARCHAR2(4) NOT NULL | Cost Element |
| 4 | CURRENCY_CD | Character(3) | VARCHAR2(3) NOT NULL | Currency Code |
| 5 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 6 | CE_RESOURCE | Character(18) | VARCHAR2(18) NOT NULL | Resource |
| 7 | SCRAP_QTY | Signed Number(13,4) | DECIMAL(11,4) NOT NULL | Scrapped Qty |
| 8 | ORIG_UOM | Character(3) | VARCHAR2(3) NOT NULL | Original Unit of Measure |
| 9 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 10 | PRODUCTION_TYPE | Character(2) | VARCHAR2(2) NOT NULL |
JNW 11/1/98 (CN#SF800-13) activated teardown xlat
PR=Production RW=Rework SV=Service TD=Teardown |
| 11 | DT_TIMESTAMP | DateTime(26) | TIMESTAMP | Date Timestamp |
| 12 | OP_SEQUENCE | Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 13 | CE_EXTENDED_COST | Signed Number(32,15) | DECIMAL(30,15) NOT NULL | Extended Cost |