WM_WO_IANTSC_VW

(SQL View)
 Index Back

WO Inspect Actv Notes Src View


SELECT ACT.BUSINESS_UNIT , ACT.WO_ID , ACT.WO_TASK_ID , ACT.INSPECTION_ID , ACT.INSP_ACTIVITY_NBR , HDR.DESCR254 AS INSPECTION_DESCR , HDR.WO_INSPL_TMPLT_ID , HDR.INSPECT_START_DTTM , TSK.BUSINESS_UNIT_AM , TSK.ASSET_ID , AST.DESCR AS ASSET_DESCR30 , AST.DESCR_LONG AS ASSET_DESCR , ACT.INSP_ACTIVITY_TYPE , ACT.DESCR50 AS INSP_ACTV_DESCR , ACT.WO_INSPECT_STATUS , ACT.EMPLID , PDT.NAME FROM 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 TSK LEFT OUTER JOIN PS_ASSET AST ON AST.BUSINESS_UNIT = TSK.BUSINESS_UNIT_AM AND AST.ASSET_ID = TSK.ASSET_ID WHERE 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 TSK.BUSINESS_UNIT = HDR.BUSINESS_UNIT AND TSK.WO_ID = HDR.WO_ID AND TSK.WO_TASK_ID = HDR.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: 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 INSPECTION_DESCR Character(254) VARCHAR2(254) NOT NULL Inspection Description
7 WO_INSPL_TMPLT_ID Character(25) VARCHAR2(25) NOT NULL Inspection Plan

Prompt Table: WM_WO_IPSRCH_VW

8 INSPECT_START_DTTM DateTime(26) TIMESTAMP Inspection Start DateTime
9 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
10 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
11 ASSET_DESCR30 Character(30) VARCHAR2(30) NOT NULL Asset Description
12 ASSET_DESCR Character(254) VARCHAR2(254) NOT NULL Asset Description
13 INSP_ACTIVITY_TYPE Character(1) VARCHAR2(1) NOT NULL Inspection Activity Type
1=Asset Verification
2=Tool Calibration
3=Data Collection
4=Trigger Evaluation
8=Sub-Plan
9=Other Logistics
14 INSP_ACTV_DESCR Character(50) VARCHAR2(50) NOT NULL Activity Description
15 WO_INSPECT_STATUS Character(2) VARCHAR2(2) NOT NULL Activity Status
01=Created
02=Assigned
03=In Progress
09=Completed
99=Terminated
16 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
17 NAME Character(50) VARCHAR2(50) NOT NULL Name