WM_WO_INAMDF_VW

(SQL View)
 Index Back

WO Inspect Alert Msg Dflts Vw


SELECT EVL.BUSINESS_UNIT , EVL.WO_ID , EVL.WO_TASK_ID , EVL.INSPECTION_ID , EVL.INSP_ACTIVITY_NBR , EVL.INSP_STEP_NBR , WOH.SRVC_GRP_ID , WOH.MAINT_TYPE , CASE WHEN WOT.CREW_SHOP <> ' ' THEN WOT.CREW_SHOP ELSE WOH.SHOP_ID END , WOH.WO_TYPE , CASE WHEN WOT.SUPERVISOR <> ' ' THEN WOT.SUPERVISOR ELSE WOH.SUPERVISOR END , CASE WHEN WOT.SCHEDULER_CODE <> ' ' THEN WOT.SCHEDULER_CODE ELSE WOH.SCHEDULER_CODE END , CASE WHEN WOT.LEAD_PERSON <> ' ' THEN WOT.LEAD_PERSON ELSE WOH.LEAD_PERSON END , WOT.BUSINESS_UNIT_AM , WOT.ASSET_ID , AST.DESCR AS ASSET_DESCR30 , AST.DESCR_LONG AS ASSET_DESCR , HDR.DESCR254 AS INSPECTION_DESCR , HDR.WO_INSPL_TMPLT_ID , HDR.WO_INSPL_EFFDT , HDR.INSPECT_START_DTTM , ACT.DESCR50 AS INSP_ACTV_DESCR , ACT.EMPLID , PDT.NAME , EVL.INSPECTION_CODE , CLC.DESCR50 AS INSP_TRGR_DESCR , CLC.INSP_CALCLT_TEXT , EVL.EVAL_BREAK_FLG , EVL.INSP_RSLT_STAT_VAL , EVL.EVAL_WRK_RESP_OPTN , EVL.EVAL_WRK_RESP_KEY1 , EVL.EVAL_WRK_RESP_KEY2 , %subrec(WM_WO_IPSAM_SBR, IPE) FROM PS_WM_WO_INSPC_EVL EVL , PS_WM_WO_INSPC_ACT ACT LEFT OUTER JOIN PS_PERSONAL_DATA PDT ON PDT.EMPLID = ACT.EMPLID , PS_WM_WO_INSPC_HDR HDR , PS_WM_WO_TSK WOT LEFT OUTER JOIN PS_ASSET AST ON AST.BUSINESS_UNIT = WOT.BUSINESS_UNIT_AM AND AST.ASSET_ID = WOT.ASSET_ID , PS_WM_WO_HDR WOH , PS_WM_WO_INSPL_EVL IPE LEFT OUTER JOIN PS_WM_INSP_CLC_HDR CLC ON CLC.SETID = IPE.SETID AND CLC.INSPECTION_CODE = IPE.INSPECTION_CODE WHERE EVL.EVAL_ALRT_MSG_OPTN > '0' AND ACT.BUSINESS_UNIT = EVL.BUSINESS_UNIT AND ACT.WO_ID = EVL.WO_ID AND ACT.WO_TASK_ID = EVL.WO_TASK_ID AND ACT.INSPECTION_ID = EVL.INSPECTION_ID AND ACT.INSP_ACTIVITY_NBR = EVL.INSP_ACTIVITY_NBR AND HDR.BUSINESS_UNIT = ACT.BUSINESS_UNIT AND HDR.WO_ID = ACT.WO_ID AND HDR.WO_TASK_ID = ACT.WO_TASK_ID AND HDR.INSPECTION_ID = ACT.INSPECTION_ID AND WOT.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND WOT.WO_ID = HDR.WO_ID AND WOT.WO_TASK_ID = HDR.WO_TASK_ID AND WOH.BUSINESS_UNIT = WOT.BUSINESS_UNIT AND WOH.WO_ID = WOT.WO_ID AND IPE.SETID = ( SELECT I.SETID FROM PS_SET_CNTRL_REC I WHERE I.SETCNTRLVALUE = EVL.BUSINESS_UNIT AND I.REC_GROUP_ID = 'WM_01' AND I.RECNAME = 'WM_WO_TMPLT_HDR') AND IPE.WO_TEMPLATE_ID = HDR.WO_INSPL_TMPLT_ID AND IPE.EFFDT = HDR.WO_INSPL_EFFDT AND IPE.INSP_ACTIVITY_NBR = EVL.INSP_ACTIVITY_NBR AND IPE.INSP_STEP_NBR = EVL.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

Default Value: 1

7 SRVC_GRP_ID Character(10) VARCHAR2(10) NOT NULL Service Group
8 MAINT_TYPE Character(10) VARCHAR2(10) NOT NULL This field is used for maintenance type
9 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
10 WO_TYPE Character(5) VARCHAR2(5) NOT NULL Work Order Type
11 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor
12 SCHEDULER_CODE Character(10) VARCHAR2(10) NOT NULL Scheduler Code
13 LEAD_PERSON Character(30) VARCHAR2(30) NOT NULL Lead Person
14 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
15 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
16 ASSET_DESCR30 Character(30) VARCHAR2(30) NOT NULL Asset Description
17 ASSET_DESCR Character(254) VARCHAR2(254) NOT NULL Asset Description
18 INSPECTION_DESCR Character(254) VARCHAR2(254) NOT NULL Inspection Description
19 WO_INSPL_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL Inspection Plan

Prompt Table: WM_WO_IPSRCH_VW

20 WO_INSPL_EFFDT Date(10) DATE Inspection Plan Effective Date
21 INSPECT_START_DTTM DateTime(26) TIMESTAMP Inspection Start DateTime
22 INSP_ACTV_DESCR Character(50) VARCHAR2(50) NOT NULL Activity Description
23 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
24 NAME Character(50) VARCHAR2(50) NOT NULL Name
25 INSPECTION_CODE Character(20) VARCHAR2(20) NOT NULL Inspection Code
26 INSP_TRGR_DESCR Character(50) VARCHAR2(50) NOT NULL Trigger Description
27 INSP_CALCLT_TEXT Long Character CLOB Calculation Text
28 EVAL_BREAK_FLG Character(1) VARCHAR2(1) NOT NULL Halt Further Evaluation
N=No
Y=Yes
29 INSP_RSLT_STAT_VAL Character(10) VARCHAR2(10) NOT NULL Result Status Value
30 EVAL_WRK_RESP_OPTN Character(1) VARCHAR2(1) NOT NULL Work Response Option
0=None
1=Create Service Request
2=Create Work Order
3=Schedule 1-Time PM
31 EVAL_WRK_RESP_KEY1 Character(5) VARCHAR2(5) NOT NULL Work Response Key1
32 EVAL_WRK_RESP_KEY2 Character(15) VARCHAR2(15) NOT NULL Work Response Key2
33 EVAL_ALRT_MSG_OPTN Character(1) VARCHAR2(1) NOT NULL Alert Message Option
0=None
1=Evaluate 'True' (only)
2=Evaluate 'Error' (only)
3=Both ('True', 'Error')

Default Value: 0

34 EVAL_ALERT_TRGR_E1 Character(25) VARCHAR2(25) NOT NULL Trigger Alert - Result 'True'

Prompt Table: WM_INALT_EFF_DV

35 EVAL_ALERT_TRGR_E2 Character(25) VARCHAR2(25) NOT NULL Trigger Alert - Result 'Error'

Prompt Table: WM_INALT_EFF_DV