SF_TRC_OPWC_VW(SQL View) |
Index Back |
|---|---|
Genealogy |
| SELECT A.BUSINESS_UNIT , A.PRODUCTION_ID , A.OP_SEQUENCE , A.WORK_CENTER_CODE , B.STORAGE_AREA , B.STOR_LEVEL_1 , B.STOR_LEVEL_2 , B.STOR_LEVEL_3 , B.STOR_LEVEL_4 , B.NON_OWN_STOR_AREA , B.NON_OWN_STOR_LEV1 , B.NON_OWN_STOR_LEV2 , B.NON_OWN_STOR_LEV3 , B.NON_OWN_STOR_LEV4 FROM PS_SF_OP_LIST A , PS_EN_WORK_CENTER B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WORK_CENTER_CODE = B.WORK_CENTER_CODE |
| # | 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 Prompt Table: SP_BUMGOP_NONVW |
| 2 | PRODUCTION_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Production ID
Prompt Table: SF_OP_MTN_VW |
| 3 | OP_SEQUENCE |
Number(4,0) | SMALLINT NOT NULL | Operation Sequence |
| 4 | WORK_CENTER_CODE | Character(10) | VARCHAR2(10) NOT NULL |
Work Center
Prompt Table: EN_WORK_CENTER |
| 5 | STORAGE_AREA | Character(5) | VARCHAR2(5) NOT NULL |
Storage Area
Prompt Table: %EDITTABLE |
| 6 | STOR_LEVEL_1 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 1
Prompt Table: %EDITTABLE2 |
| 7 | STOR_LEVEL_2 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 2
Prompt Table: %EDITTABLE3 |
| 8 | STOR_LEVEL_3 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 3
Prompt Table: %EDITTABLE4 |
| 9 | STOR_LEVEL_4 | Character(4) | VARCHAR2(4) NOT NULL |
Storage Level 4
Prompt Table: %EDITTABLE5 |
| 10 | NON_OWN_STOR_AREA | Character(5) | VARCHAR2(5) NOT NULL |
Non Own Storage Area
Prompt Table: %EDITTABLE6 |
| 11 | NON_OWN_STOR_LEV1 | Character(4) | VARCHAR2(4) NOT NULL |
Non Owned Storage Level 1
Prompt Table: %EDITTABLE7 |
| 12 | NON_OWN_STOR_LEV2 | Character(4) | VARCHAR2(4) NOT NULL |
Non Own Storage Level 2
Prompt Table: %EDITTABLE8 |
| 13 | NON_OWN_STOR_LEV3 | Character(4) | VARCHAR2(4) NOT NULL |
Non Own Storage Level 3
Prompt Table: %EDITTABLE9 |
| 14 | NON_OWN_STOR_LEV4 | Character(4) | VARCHAR2(4) NOT NULL |
Non Own Storage Level 4
Prompt Table: %EDITTABLE10 |