WM_WR_OPNWO2_VW

(SQL View)
 Index Back

WR Asset Open Work Orders Vw2


SELECT A.BUSINESS_UNIT_AM , A.ASSET_ID , A.BUSINESS_UNIT , A.WO_ID , B.WO_TYPE , B.DESCR254 , B.INTERNAL_STATUS , B.LAST_TASK_ID , B.SRVC_GRP_ID , B.SHOP_ID , B.PRIORITY_CD , B.MAINT_TYPE , B.WO_SOURCE_CD , B.WO_APPROVAL_STATUS , B.REQ_START_DT , B.REQ_END_DT , B.BUSINESS_UNIT_WR , B.WR_ID , ( SELECT COUNT(*) FROM PS_WM_WO_ASSCSR_VW I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.WO_ID = A.WO_ID) AS WO_ASSOC_WRID_CNT , B.BUSINESS_UNIT_PC , B.PROJECT_ID , B.SCHEDULER_CODE , B.SUPERVISOR , B.LEAD_PERSON , CASE WHEN B.ASSET_ID = A.ASSET_ID THEN 'Y' ELSE 'N' END FROM PS_WM_WR_OPNWO1_VW A , PS_WM_WO_HDR B WHERE A.WR_ASSET_OPEN_WOS = 'Y' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: SP_BU_AM_NONVW

2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
3 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit

Prompt Table: SP_BU_WM_NONVW

4 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
5 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

6 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
7 INTERNAL_STATUS Character(2) VARCHAR2(2) NOT NULL Internal Status
01=Open
02=Awaiting Schedule
03=Scheduled
04=Work In Progress
05=Complete
06=Closed
07=Canceled
08=On Hold
09=Work Order Created
8 LAST_TASK_ID Number(8,0) INTEGER NOT NULL Last Task ID
9 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group

Prompt Table: WM_SRVC_GRP_BU

10 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification

Prompt Table: WM_SHOP_LOC_VW

11 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code

Prompt Table: WM_PRIORITY

12 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type

Prompt Table: MAINT_TYPE_TBL
Set Control Field: BUSINESS_UNIT

13 WO_SOURCE_CD Character(4) VARCHAR2(4) NOT NULL Work order source code
1=Third Party
2=CRM Help Desk
3=Work Order
4=Service Request
5=Preventive Maintenance
6=Project Costing
7=Express Work Order
8=Condition-based Maintenance
9=WO Inspection
14 WO_APPROVAL_STATUS Character(1) VARCHAR2(1) NOT NULL work order approval status
A=Approved
C=Cancelled
E=Denied
I=Initial
P=Pending Approval
15 REQ_START_DT Date(10) DATE Required Start
16 REQ_END_DT Date(10) DATE Required End
17 BUSINESS_UNIT_WR Character(5) VARCHAR2(5) NOT NULL Work Request Business Unit

Prompt Table: SP_BU_WR_NONVW

18 WR_ID Character(15) VARCHAR2(15) NOT NULL Work Request ID

Prompt Table: WM_WR_WO_SRCH

19 WO_ASSOC_WRID_CNT Number(3,0) SMALLINT NOT NULL WO Service Request Count
20 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Prompt Table: BUS_UNIT_TBL_PC

21 PROJECT_ID Character(15) VARCHAR2(15) NOT NULL Project Id ChartField

Prompt Table: WM_PC_PRJ_DVW

22 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code

Prompt Table: WM_SHOP_SCHEDLR

23 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: WM_SHOP_RES_VW

24 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person

Prompt Table: WM_OPRID_VW

25 WO_PRIM_ASSET_FLG Character(1) VARCHAR2(1) NOT NULL WO Primary Asset
N=No
Y=Yes