BUSINESS_UNITPrompt Table: SP_BUMGOP_NONVW
Prompt Table: SF_PRDN_AREA
CE_GROUP_VW(SQL View) |
Index Back |
|---|---|
Schedules that are not Grouped |
| SELECT BUSINESS_UNIT ,INV_ITEM_ID , PRODUCTION_ID , PRDN_AREA_CODE , PRDN_DUE_DATE , PRDN_START_SHIFT , NEW_END_DATE FROM PS_SF_PRDNID_HEADR WHERE MA_PRDN_ID_FLG = 'N' AND NOT EXISTS ( SELECT 'X' FROM PS_CE_GROUP_LINE WHERE PS_SF_PRDNID_HEADR.BUSINESS_UNIT = PS_CE_GROUP_LINE.BUSINESS_UNIT AND PS_SF_PRDNID_HEADR.PRODUCTION_ID = PS_CE_GROUP_LINE.PRODUCTION_ID) |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Prompt Table: SP_BUMGOP_NONVW |
| 2 | INV_ITEM_ID | Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 3 | PRODUCTION_ID | Character(10) | VARCHAR2(10) NOT NULL | Production ID |
| 4 | PRDN_AREA_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Production Area
Prompt Table: SF_PRDN_AREA |
| 5 | PRDN_DUE_DATE | Date(10) | DATE | Prdn Due Date |
| 6 | PRDN_START_SHIFT | Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Start Shift |
| 7 | NEW_END_DATE | Date(10) | DATE | Due Date |