WM_WO_NOT_CMPLT(SQL View) |
Index Back |
|---|---|
Work Orders not Closed/Cancel |
| SELECT BUSINESS_UNIT , WO_ID , DESCR254 , SHOP_ID , PRIORITY_CD , SRVC_GRP_ID , WO_TYPE , STATUS_CD , MAINT_TYPE , BUSINESS_UNIT_AM , ASSET_ID FROM PS_WM_WO_HDR WHERE INTERNAL_STATUS NOT IN('05','06', '07') AND WO_APPROVAL_STATUS = 'A' |
| # | PeopleSoft Field Name | PeopleSoft Field Type | Database Column Type | Description |
|---|---|---|---|---|
| 1 |  BUSINESS_UNIT_WO |
Character(5) | VARCHAR2(5) NOT NULL | Business Unit Work Order |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL | Work Order Identification |
| 3 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 4 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Prompt Table: WM_SHOP_WOBU_VW |
| 5 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table:
WM_PRIORITY
|
| 6 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Prompt Table:
WM_SRVC_GRP_WBU
|
| 7 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table:
WM_WO_TYPE
|
| 8 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table:
WM_STATUS_HDR
|
| 9 | MAINT_TYPE | Character(10) | VARCHAR2(10) NOT NULL |
This field is used for maintenance type
Prompt Table:
MAINT_TYPE_TBL
|
| 10 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 11 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL |
Asset Identification
Prompt Table:
WM_ASSET_VWA
|