WM_WOE_RPT_VW(SQL View) |
Index Back |
|---|
| SELECT R.PROCESS_INSTANCE , R.OPRID , R.RUN_CNTL_ID , R.BUSINESS_UNIT , T.WO_ID , T.WO_TASK_ID , T.SEQ_NBR , R.WM_RPT_SW01 , R.WM_RPT_SW02 , R.WM_RPT_SW03 , R.WM_RPT_SW04 , R.WM_RPT_SW05 , R.WM_RPT_SW06 , R.WM_RPT_SW07 , R.WM_RPT_SW08 , R.WM_RPT_SW09 , R.WM_RPT_SW10 , R.MULTIPLE_FLG FROM PS_WM_WOE_RPT_REQ R , PS_WM_WOE_RPT_CRIT T WHERE R.PROCESS_INSTANCE = T.PROCESS_INSTANCE AND R.OPRID = T.OPRID AND R.RUN_CNTL_ID = T.RUN_CNTL_ID AND R.BUSINESS_UNIT = T.BUSINESS_UNIT |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  PROCESS_INSTANCE |
Number(10,0) | DECIMAL(10) NOT NULL | Process Instance |
| 2 | OPRID |
Character(30) | VARCHAR2(30) NOT NULL |
A user's ID (see PSOPRDEFN).
Default Value: OPR_DEF_TBL_FS.OPRID Prompt Table: OPRID_VW |
| 3 | RUN_CNTL_ID |
Character(30) | VARCHAR2(30) NOT NULL | Run Control ID |
| 4 | BUSINESS_UNIT |
Character(5) | VARCHAR2(5) NOT NULL |
Business Unit
Default Value: OPR_DEF_TBL_FS.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW |
| 5 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 6 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL | Task Number |
| 7 | SEQ_NBR |
Number(15,0) | DECIMAL(15) NOT NULL | Sequence Number |
| 8 | WM_RPT_SW01 | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Tasks Report
Y/N Table Edit |
| 9 | WM_RPT_SW02 | Character(1) | VARCHAR2(1) NOT NULL |
Labor Assignment Report
Y/N Table Edit |
| 10 | WM_RPT_SW03 | Character(1) | VARCHAR2(1) NOT NULL |
Tools Assignment Report
Y/N Table Edit |
| 11 | WM_RPT_SW04 | Character(1) | VARCHAR2(1) NOT NULL |
Material Assignment Report
Y/N Table Edit |
| 12 | WM_RPT_SW05 | Character(1) | VARCHAR2(1) NOT NULL |
Procurement/On-hand Report
Y/N Table Edit |
| 13 | WM_RPT_SW06 | Character(1) | VARCHAR2(1) NOT NULL |
Check List Report
Y/N Table Edit |
| 14 | WM_RPT_SW07 | Character(1) | VARCHAR2(1) NOT NULL |
Instruction Report
Y/N Table Edit |
| 15 | WM_RPT_SW08 | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Notes Report
Y/N Table Edit |
| 16 | WM_RPT_SW09 | Character(1) | VARCHAR2(1) NOT NULL |
Work Order Task Notes Report
Y/N Table Edit |
| 17 | WM_RPT_SW10 | Character(1) | VARCHAR2(1) NOT NULL |
Equipment Parts List
Y/N Table Edit |
| 18 | MULTIPLE_FLG | Character(1) | VARCHAR2(1) NOT NULL | Allow Multiple Values per Attr |