WM_WO_INSP_VW

(SQL View)
 Index Back

SELECT DISTINCT B.OPRID , B.BUSINESS_UNIT , B.WO_ID , B.WO_TASK_ID , I.INSPECTION_ID , L.EMPLID , B.CHECKED , L.RES_LN_NBR , I.DESCR254 , W.DESCR254 , T.ALERT_INDICATOR , T.BUSINESS_UNIT_AM , T.ASSET_ID , T.ASSET_LOCATION , T.LOCATION , I.WO_INSPECT_STATUS , I.INSP_RSLT_STAT_VAL , I.WO_DURATION , I.WO_DURATION2 , T.STATUS_CD , T.STATUS_DTTM , S.DESCR , T.INTERNAL_STATUS , W.PRIORITY_CD , T.TASK_ACTION , L.SHOP_ID , T.SUPERVISOR , T.REQ_START_DT , T.REQ_START_TIME , T.REQ_END_DT , T.REQ_END_TIME , (CASE WHEN L.SCHED_START_DT IS NULL THEN T.SCHED_START_DT ELSE L.SCHED_START_DT END) , (CASE WHEN L.SCHED_START_TIME IS NULL THEN T.SCHED_START_TIME ELSE L.SCHED_START_TIME END) , (CASE WHEN L.SCHED_END_DT IS NULL THEN T.SCHED_END_DT ELSE L.SCHED_END_DT END) , (CASE WHEN L.SCHED_END_TIME IS NULL THEN T.SCHED_END_TIME ELSE L.SCHED_END_TIME END) , T.BUSINESS_UNIT_PC , T.PROJECT_ID , T.ACTIVITY_ID , T.LEAD_PERSON , T.SCHEDULER_CODE , T.ACTL_START_DT , T.ACTL_START_TIME , T.ACTL_END_DT , T.ACTL_END_TIME , L.ACTL_START_DT , L.ACTL_START_TIME , L.ACTL_END_DT , L.ACTL_END_TIME , T.SCHED_START_DT , T.SCHED_START_TIME , T.SCHED_END_DT , T.SCHED_END_TIME , T.PROBLEM_GROUP , T.PROBLEM_CD , T.CAUSE_CD , T.RESOLUTION_CD , GIS.SETID , GIS.EFFDT , GIS.ADDRESS1 , GIS.ADDRESS2 , GIS.ADDRESS3 , GIS.ADDRESS4 , GIS.CITY , GIS.STATE , GIS.POSTAL , GIS.COUNTRY , GIS.COUNTRY_2CHAR , GIS.LONGITUDE , GIS.LATITUDE , W.PM_SCHD_ID FROM PS_WM_WOE_WB B JOIN PS_FS_GIS_TASK_VW GIS ON GIS.BUSINESS_UNIT = B.BUSINESS_UNIT AND GIS.WO_ID = B.WO_ID AND GIS.WO_TASK_ID = B.WO_TASK_ID LEFT OUTER JOIN PS_WM_WO_SCHED_LBR L ON %Join(COMMON_KEYS, WM_WOE_TW_VW B, WM_WO_SCHED_LBR L) AND B.RES_LN_NBR = L.RES_LN_NBR , PS_WM_WO_HDR W , PS_WM_WO_TSK T , PS_WM_STATUS_TSK S , PS_WM_WO_INSUPD_VW I WHERE B.WORKBENCH_CD = 'I' AND %Join(COMMON_KEYS, WM_WOE_TW_VW B, WM_WO_TSK T) AND %Join(COMMON_KEYS, WM_WO_HDR W, WM_WO_TSK T) AND I.BUSINESS_UNIT = T.BUSINESS_UNIT AND I.WO_ID = T.WO_ID AND I.WO_TASK_ID = T.WO_TASK_ID AND I.INSPECTION_ID <> ' ' AND S.SETID = ( SELECT SETID FROM PS_SET_CNTRL_REC WHERE RECNAME = 'WM_STATUS_TSK' AND SETCNTRLVALUE = T.BUSINESS_UNIT) AND S.STATUS_CD = T.STATUS_CD

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 OPRID Character(30) VARCHAR2(30) NOT NULL A user's ID (see PSOPRDEFN).
2 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
3 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
4 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
5 INSPECTION_ID Character(10) VARCHAR2(10) NOT NULL Inspection ID
6 EMPLID Character(11) VARCHAR2(11) NOT NULL Employee ID
7 CHECKED Character(1) VARCHAR2(1) NOT NULL Check box for Reason Code
N=No
Y=Yes
8 RES_LN_NBR Number(5,0) INTEGER NOT NULL Resource Line No.
9 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
10 DESCR254_MIXED Character(254) VARCHAR2(254) NOT NULL Description
11 ALERT_INDICATOR Character(3) VARCHAR2(3) NOT NULL Note alert indicator
000=None
001=Outstanding Request
002=Reply Received
12 BUSINESS_UNIT_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit

Prompt Table: BUS_UNIT_AM_VW

13 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
14 ASSET_LOCATION Character(10) VARCHAR2(10) NOT NULL Asset Location

Prompt Table: ASSET_LOCATION

15 LOCATION Character(10) VARCHAR2(10) NOT NULL Location Code

Prompt Table: LOCATION_TBL

16 WO_INSPECT_STATUS Character(2) VARCHAR2(2) NOT NULL Inspection Status
01=Created
02=Assigned
03=In Progress
09=Completed
99=Terminated
17 INSP_RSLT_STAT_VAL Character(10) VARCHAR2(10) NOT NULL Result Status Value

Prompt Table: WM_WO_IPRSVL_VW

18 WO_DURATION Number(8,2) DECIMAL(7,2) NOT NULL Estimated Work Order Duration
19 WO_DURATION2 Number(8,2) DECIMAL(7,2) NOT NULL Work Order Duration
20 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
21 STATUS_DTTM DateTime(26) TIMESTAMP 05/13/02 EGS (CN#PL900-1): Added
22 DESCR Character(30) VARCHAR2(30) NOT NULL Description
23 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
24 PRIORITY_CD Character(3) VARCHAR2(3) NOT NULL Priority Code
25 TASK_ACTION Character(1) VARCHAR2(1) NOT NULL The purpose of this field is to identify the kind of action that may be done for a task.
1=No Change
2=Install Component
3=Repair
4=Remove
5=Retire
6=Remove and Sell
7=Replacement asset
8=Ownership Change
26 SHOP_ID Character(10) VARCHAR2(10) NOT NULL Shop Identification
27 SUPERVISOR Character(30) VARCHAR2(30) NOT NULL Supervisor

Prompt Table: PERSONAL_DATA

28 REQ_START_DT Date(10) DATE Required Start
29 REQ_START_TIME Time(15) TIMESTAMP Required Start Time
30 REQ_END_DT Date(10) DATE Required End
31 REQ_END_TIME Time(15) TIMESTAMP Required End Time
32 SCHED_START_DT Date(10) DATE Scheduled Start Date
33 SCHED_START_TIME Time(15) TIMESTAMP Schedule Start Time
34 SCHED_END_DT Date(10) DATE Scheduled End Date
35 SCHED_END_TIME Time(15) TIMESTAMP Schedule End Time
36 BUSINESS_UNIT_PC Character(5) VARCHAR2(5) NOT NULL PC Business Unit

Default Value: BUS_UNIT_TBL_WM.BUSINESS_UNIT_PC

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

Default Value: WM_WO_HDR.PROJECT_ID

Prompt Table: WM_PC_PRJ_VW

38 ACTIVITY_ID Character(15) VARCHAR2(15) NOT NULL Activity ID

Prompt Table: PROJ_ACTIVITY

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

Prompt Table: PERSONAL_DATA

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

Prompt Table: WM_SHOP_SCHEDLR

41 ACTL_START_DT Date(10) DATE Actual Start Date
42 ACTL_START_TIME Time(15) TIMESTAMP Actual Start Time
43 ACTL_END_DT Date(10) DATE Actual End Date
44 ACTL_END_TIME Time(15) TIMESTAMP Actual End Time
45 START_DT Date(10) DATE Start Date
46 START_TIME Time(15) TIMESTAMP Start of Shift
47 END_DT Date(10) DATE End Date
48 END_TIME Time(15) TIMESTAMP End of Shift
49 START_DATE Date(10) DATE Start Date for Gen Standing PO
50 START_TM Time(15) TIMESTAMP Represents the process starting time associated with position calculation.
51 END_DATE Date(10) DATE End Date
52 END_TM Time(15) TIMESTAMP End Time
53 PROBLEM_GROUP Character(15) VARCHAR2(15) NOT NULL Problem Group

Prompt Table: WM_PCR_CLSF_DVW

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

Prompt Table: WM_PCR_PRBAC_VW

55 CAUSE_CD Character(15) VARCHAR2(15) NOT NULL Cause Code

Prompt Table: WM_PCR_CSEAC_VW

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

Prompt Table: WM_PCR_RESAC_VW

57 SETID Character(5) VARCHAR2(5) NOT NULL SetID
58 EFFDT Date(10) DATE Effective Date

Default Value: %date

59 ADDRESS1 Character(55) VARCHAR2(55) NOT NULL Address 1
60 ADDRESS2 Character(55) VARCHAR2(55) NOT NULL Address 2
61 ADDRESS3 Character(55) VARCHAR2(55) NOT NULL Address 3
62 ADDRESS4 Character(55) VARCHAR2(55) NOT NULL Address 4
63 CITY Character(30) VARCHAR2(30) NOT NULL City
64 STATE Character(6) VARCHAR2(6) NOT NULL State
65 POSTAL Character(12) VARCHAR2(12) NOT NULL Postal
66 COUNTRY Character(3) VARCHAR2(3) NOT NULL Country
67 COUNTRY_2CHAR Character(2) VARCHAR2(2) NOT NULL 2-Char Country Code
68 LONGITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Longitude
69 LATITUDE Signed Number(12,7) DECIMAL(10,7) NOT NULL Latitude
70 PM_SCHD_ID Character(10) VARCHAR2(10) NOT NULL Preventive Maintenance Schedule ID