WM_WO_POINQ_VW(SQL View) |
Index Back |
|---|---|
Procurement Inquiry ViewView used to find a Work Orders that has procurement transactions. |
| SELECT A.BUSINESS_UNIT , A.WO_ID , B.WO_TASK_ID , A.WO_TYPE , A.SRVC_GRP_ID , A.SHOP_ID , A.PRIORITY_CD , B.STATUS_CD , B.DESCR254 , B.SCHED_START_DT , %Dttm(B.SCHED_START_DT, B.SCHED_START_TIME) , B.SCHED_END_DT , %Dttm(B.SCHED_END_DT, B.SCHED_END_TIME) , B.BUSINESS_UNIT_AM , B.ASSET_ID , B.ASSET_LOCATION , B.AREA_ID FROM PS_WM_WO_HDR A , PS_WM_WO_TSK B WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.WO_ID = B.WO_ID AND (EXISTS ( SELECT 'X' FROM PS_WM_WO_PO_HASH I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.WO_ID = A.WO_ID AND I.WO_TASK_ID = B.WO_TASK_ID) OR EXISTS ( SELECT 'X' FROM PS_POREQ_WO_XREF J WHERE J.BUSINESS_UNIT_WO = A.BUSINESS_UNIT AND J.WO_ID = A.WO_ID AND J.WO_TASK_ID = B.WO_TASK_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_WM.BUSINESS_UNIT Prompt Table: SP_BU_WM_NONVW |
| 2 | WO_ID |
Character(10) | VARCHAR2(10) NOT NULL |
Work Order Identification
Prompt Table: WM_WO_HDR |
| 3 | WO_TASK_ID |
Number(5,0) | INTEGER NOT NULL |
Task Number
Prompt Table: WM_WO_TSK |
| 4 | WO_TYPE | Character(5) | VARCHAR2(5) NOT NULL |
Work Order Type
Prompt Table: WM_WO_TYPE |
| 5 | SRVC_GRP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Service Group
Default Value: OPR_DEF_TBL_WM.SRVC_GRP_ID Prompt Table: WM_SRVC_GRP_BU |
| 6 | SHOP_ID | Character(10) | VARCHAR2(10) NOT NULL |
Shop Identification
Default Value: OPR_DEF_TBL_WM.SHOP_ID Prompt Table: WM_SHOP_HDR |
| 7 | PRIORITY_CD | Character(3) | VARCHAR2(3) NOT NULL |
Priority Code
Prompt Table: WM_PRIORITY |
| 8 | STATUS_CD | Character(4) | VARCHAR2(4) NOT NULL |
User defined Status Code
Prompt Table: WM_STATUS_TSK |
| 9 | DESCR254 | Character(254) | VARCHAR2(254) NOT NULL | Description of length 254 |
| 10 | SCHED_START_DT | Date(10) | DATE | Scheduled Start Date |
| 11 | SCHED_START_DTTM | DateTime(26) | TIMESTAMP | Schedule Start Datetime |
| 12 | SCHED_END_DT | Date(10) | DATE | Scheduled End Date |
| 13 | SCHED_END_DTTM | DateTime(26) | TIMESTAMP | Schedule End Datetime |
| 14 | BUSINESS_UNIT_AM | Character(5) | VARCHAR2(5) NOT NULL |
AM Business Unit
Prompt Table: SP_BU_AM_NONVW |
| 15 | ASSET_ID | Character(12) | VARCHAR2(12) NOT NULL | Asset Identification |
| 16 | ASSET_LOCATION | Character(10) | VARCHAR2(10) NOT NULL | Asset Location |
| 17 | AREA_ID | Character(10) | VARCHAR2(10) NOT NULL | Area ID |