BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
PRDN_AREA_CODEINV_ITEM_IDPRDN_DUE_DATEPRDN_DUE_SHIFTOP_SEQUENCESF_OP_SCH2_VW(SQL View) |
Index Back |
|---|---|
Op List Sel Due Date View |
| SELECT DISTINCT A.BUSINESS_UNIT , A.PRDN_AREA_CODE , A.INV_ITEM_ID , A.PRDN_DUE_DATE , A.PRDN_DUE_SHIFT , B.OP_SEQUENCE FROM PS_SF_PRDNID_HEADR A , PS_SF_COMP_LIST B WHERE A.MA_PRDN_ID_FLG = 'N' AND A.PROD_STATUS IN ('15','20','30') AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.PRODUCTION_ID = A.PRODUCTION_ID |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT |
| 2 | PRDN_AREA_CODE |
Character(10) | VARCHAR2(10) NOT NULL | Production Area |
| 3 | INV_ITEM_ID |
Character(18) | VARCHAR2(18) NOT NULL | Item ID |
| 4 | PRDN_DUE_DATE |
Date(10) | DATE | Prdn Due Date |
| 5 | PRDN_DUE_SHIFT |
Signed Number(2,0) | DECIMAL(1) NOT NULL | Prdn Due Shift |
| 6 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |