WM_WO_INWRDF_VW

(SQL View)
 Index Back

WO Inspect Wrk Resp Dflts View


SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , A.INSPECTION_ID , A.INSP_ACTIVITY_NBR , A.INSP_STEP_NBR , CASE WHEN E.SRVC_GRP_ID = B.SRVC_GRP_ID OR E.SRVC_GRP_ID = ' ' THEN B.SHOP_ID ELSE ' ' END , C.BUSINESS_UNIT_AM , C.ASSET_ID , C.ASSET_LOCATION , C.AREA_ID , D.WO_INSPL_TMPLT_ID , D.WO_INSPL_EFFDT , %subrec(WM_WO_IPCSR_SBR, E) , %subrec(WM_WO_IPCWO_SBR, E) , %subrec(WM_WO_IPSPM_SBR, E) , CASE WHEN E.SRVC_GRP_ID <> ' ' THEN E.SRVC_GRP_ID ELSE B.SRVC_GRP_ID END , E.MAINT_TYPE , E.WO_JOB_TMPLT_ID , E.PROBLEM_GROUP , E.PROBLEM_CD FROM PS_WM_WO_INSPC_EVL A , PS_WM_WO_HDR B , PS_WM_WO_TSK C , PS_WM_WO_INSPC_HDR D , PS_WM_WO_INSPL_EVL E WHERE A.EVAL_WRK_RESP_OPTN > '0' AND B.BUSINESS_UNIT = A.BUSINESS_UNIT AND B.WO_ID = A.WO_ID AND C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.WO_ID = A.WO_ID AND C.WO_TASK_ID = A.WO_TASK_ID AND D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.WO_ID = A.WO_ID AND D.WO_TASK_ID = A.WO_TASK_ID AND D.INSPECTION_ID = A.INSPECTION_ID AND E.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = A.BUSINESS_UNIT AND I.REC_GROUP_ID = 'WM_01' AND I.RECNAME = 'WM_WO_TMPLT_HDR') AND E.WO_TEMPLATE_ID = D.WO_INSPL_TMPLT_ID AND E.EFFDT = D.WO_INSPL_EFFDT AND E.INSP_ACTIVITY_NBR = A.INSP_ACTIVITY_NBR AND E.INSP_STEP_NBR = A.INSP_STEP_NBR

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

Default Value: WM_WO_INSPC_ACT.BUSINESS_UNIT

Prompt Table: SP_BU_WM_NONVW

2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification

Default Value: WM_WO_INSPC_ACT.WO_ID

3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number

Default Value: WM_WO_INSPC_ACT.WO_TASK_ID

4 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Inspection ID

Default Value: WM_WO_INSPC_ACT.INSPECTION_ID

5 INSP_ACTIVITY_NBR Number(5,0) INTEGER NOT NULL Activity Number

Default Value: WM_WO_INSPC_ACT.INSP_ACTIVITY_NBR

6 INSP_STEP_NBR Number(5,0) INTEGER NOT NULL Step Number
7 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
8 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
9 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
10 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location
11 AREA_ID Character(10) VARCHAR2(10) NOT NULL Area ID
12 WO_INSPL_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL Inspection Plan

Prompt Table: WM_WO_IPSRCH_VW

13 WO_INSPL_EFFDT Date(10) DATE Inspection Plan Effective Date
14 WR_PRIORITY Character(1) VARCHAR2(1) NOT NULL Service Request Priority
1=1-Critical
2=2-Urgent
3=3-Standard
4=4-Low
15 TREE_NODE Character(20) VARCHAR2(20) NOT NULL Node name

Prompt Table: WM_WO_IPPRB_DVW

16 WR_SUBJECT Character(60) VARCHAR2(60) NOT NULL Subject
17 DESCRLONG Long Character CLOB Long Description
18 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type

Prompt Table: WM_WO_TYPE

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

Prompt Table: WM_PRIORITY

20 WO_APPRVL_FLG Character(1) VARCHAR2(1) NOT NULL Work Management Approval
1=Pre-Approved
3=Workflow Approval
21 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
22 CAUSE_CD Character(15) VARCHAR2(15) NOT NULL Cause Code

Prompt Table: WM_PCR_CSEAC_VW

23 RESOLUTION_CD Character(15) VARCHAR2(15) NOT NULL Resolution code

Prompt Table: WM_PCR_RESAC_VW

24 PM_SCHD_TYPE Character(1) VARCHAR2(1) NOT NULL PM Schedule Type
1=Asset
2=Maintenance Loop
3=Location
25 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

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

Prompt Table: WM_MNTTP_EFF_VW

27 WO_JOB_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL WO Job Template ID (specific field)

Prompt Table: WM_WO_JTMPL_DVW

28 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_CLSF_DVW

29 PROBLEM_CD Character(15) VARCHAR2(15) NOT NULL Problem code

Prompt Table: WM_PCR_PRBAC_VW