CE_UNGROUP_VW(SQL View) |
Index Back |
|---|---|
View of Group ID's |
| SELECT A.BUSINESS_UNIT , A.CE_GRP_PID_ID , A.PRODUCTION_ID , A.INV_ITEM_ID , A.PRDN_AREA_CODE , A.PRDN_DUE_DATE , A.PRDN_START_SHIFT , A.OPRID , A.CURRENT_DTTM FROM PS_CE_GROUP_LINE A , PS_SF_PRDNID_HEADR B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.PRODUCTION_ID = B.PRODUCTION_ID AND B.PROD_STATUS < '60' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT | Character(5) | VARCHAR2(5) NOT NULL | Business Unit |
| 2 | CE_GRP_PID_ID | Character(10) | VARCHAR2(10) NOT NULL | Schedule Group ID |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 5 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 6 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
| 7 | PRDN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 8 | OPRID | Character(30) | VARCHAR2(30) NOT NULL | A user's ID (see PSOPRDEFN). |
| 9 | CURRENT_DTTM | DateTime(26) | TIMESTAMP | 08/27/01 EGS (CN#PL900-1.0): Added |