BUSINESS_UNITDefault Value: OPR_DEF_TBL_FS.BUSINESS_UNIT
WO_IDWO_TASK_IDDefault Value: 1
WM_WOT_OPEN_VW(SQL View) |
Index Back |
|---|
| SELECT DISTINCT T.BUSINESS_UNIT , T.WO_ID , T.WO_TASK_ID , T.DESCR254 , T.STATUS_CD , T.STATUS_DTTM FROM PS_WM_WO_TSK T WHERE T.INTERNAL_STATUS NOT IN ('06', '07', '08', '09') |
| # | 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 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL |
Task Number
Default Value: 1 |
| 4 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 5 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL | User defined Status Code |
| 6 | STATUS_DTTM | DateTime(26) | TIMESTAMP | 05/13/02 EGS (CN#PL900-1): Added |