WM_WOTSK_ADT_VW

(SQL View)
 Index Back

WO Actual Downtime View

Used in Work Order Failure Tracking page to support related field display

SELECT A.BUSINESS_UNIT , A.WO_ID , A.WO_TASK_ID , ( SELECT MIN(%Dttm(I.ACTL_START_DT, I.ACTL_START_TIME)) FROM PS_WM_WO_DWNTME I WHERE I.BUSINESS_UNIT = A.BUSINESS_UNIT AND I.WO_ID = A.WO_ID AND I.WO_TASK_ID = A.WO_TASK_ID ) , ( SELECT MAX(%Dttm(J.ACTL_END_DT, J.ACTL_END_TIME)) FROM PS_WM_WO_DWNTME J WHERE J.BUSINESS_UNIT = A.BUSINESS_UNIT AND J.WO_ID = A.WO_ID AND J.WO_TASK_ID = A.WO_TASK_ID ) , ( SELECT SUM(K.DOWN_HOURS) FROM PS_WM_WO_DWNTME K WHERE K.BUSINESS_UNIT = A.BUSINESS_UNIT AND K.WO_ID = A.WO_ID AND K.WO_TASK_ID = A.WO_TASK_ID) , A.ACTL_COST_LBR , A.ACTL_COST_MAT , A.ACTL_COST_PO , A.ACTL_COST_TLS , (A.ACTL_COST_LBR + A.ACTL_COST_MAT + A.ACTL_COST_PO + A.ACTL_COST_TLS), A.CURRENCY_CD FROM PS_WM_WO_TSK A

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification
3 WO_TASK_ID Number(5,0) INTEGER NOT NULL Task Number
4 ACTL_START_DTTM DateTime(26) TIMESTAMP Actual Start Date/Time
5 ACTL_END_DTTM DateTime(26) TIMESTAMP Actual End Date/Time
6 ASSET_DOWNTIME_HRS Number(32,3) DECIMAL(31,3) NOT NULL Asset Downtime
7 ACTL_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Labor Cost
8 ACTL_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Cost
9 ACTL_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual procurement costs for a work order
10 ACTL_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost
11 ACTL_COST_TOT Number(27,3) DECIMAL(26,3) NOT NULL Actual Total Cost
12 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Prompt Table: CURR_CD_EFF_VW