WM_COST_VAR_VW

(SQL View)
 Index Back

SELECT A.BUSINESS_UNIT , A.WO_ID , A.SCHED_COST_LBR , A.SCHED_COST_MAT , A.SCHED_COST_TLS , A.SCHED_COST_PO , A.ACTL_COST_LBR , A.ACTL_COST_MAT , A.ACTL_COST_TLS , A.ACTL_COST_PO , A.EST_COST_LBR , A.EST_COST_MAT , A.EST_COST_TLS , A.EST_COST_PO , A.CURRENCY_CD , (A.EST_COST_LBR + A.EST_COST_MAT + A.EST_COST_TLS + A.EST_COST_PO) - (A.ACTL_COST_LBR + A.ACTL_COST_MAT + A.ACTL_COST_TLS + A.ACTL_COST_PO) , (A.SCHED_COST_LBR + A.SCHED_COST_MAT + A.SCHED_COST_TLS + A.SCHED_COST_PO) - (A.ACTL_COST_LBR + A.ACTL_COST_MAT + A.ACTL_COST_TLS + A.ACTL_COST_PO) , CASE WHEN (A.EST_COST_LBR + A.EST_COST_MAT + A.EST_COST_TLS + A.EST_COST_PO) <> 0 THEN %DecMult(%DecDiv((A.EST_COST_LBR + A.EST_COST_MAT + A.EST_COST_TLS + A.EST_COST_PO) - (A.ACTL_COST_LBR + A.ACTL_COST_MAT + A.ACTL_COST_TLS + A.ACTL_COST_PO) , (A.EST_COST_LBR + A.EST_COST_MAT + A.EST_COST_TLS + A.EST_COST_PO) ),100) ELSE 0 END , CASE WHEN (A.SCHED_COST_LBR + A.SCHED_COST_MAT + A.SCHED_COST_TLS + A.SCHED_COST_PO) <> 0 THEN %DecMult(%DecDiv((A.SCHED_COST_LBR + A.SCHED_COST_MAT + A.SCHED_COST_TLS + A.SCHED_COST_PO) - (A.ACTL_COST_LBR + A.ACTL_COST_MAT + A.ACTL_COST_TLS + A.ACTL_COST_PO), (A.SCHED_COST_LBR + A.SCHED_COST_MAT + A.SCHED_COST_TLS + A.SCHED_COST_PO) ),100) ELSE 0 END , G.DESCR , D.DESCRSHORT , E.DESCRSHORT FROM PS_WM_WO_HDR A , PS_WM_STATUS_HDR G , PS_WM_PRIORITY D , PS_WM_WO_TYPE E WHERE A.STATUS_CD = G.STATUS_CD AND G.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.RECNAME = 'WM_STATUS_HDR' ) AND A.PRIORITY_CD = D.PRIORITY_CD AND D.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.RECNAME = 'WM_PRIORITY' ) AND A.WO_TYPE = E.WO_TYPE AND E.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = A.BUSINESS_UNIT AND F.RECNAME = 'WM_WO_TYPE' )

# 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 SCHED_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used by WOM to store Scheduled Labor Cost
4 SCHED_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Cost of Scheduled Materials
5 SCHED_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Schedule Tools Cost
6 SCHED_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL This field will be used to store the Scheduled cost of Procurement
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_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost
10 ACTL_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual procurement costs for a work order
11 EST_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Cost
12 EST_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Material Cost
13 EST_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Tools Cost
14 EST_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Procurement costs for a work order
15 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code

Default Value: BUS_UNIT_TBL_WM.BASE_CURRENCY

16 VARIANCE_COST_TOT Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Variance Cost
17 VARIANCE_COST_TOT2 Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Variance Cost
18 WM_VARIANCE_PCT Signed Number(4,0) DECIMAL(3) NOT NULL Cost Variance %
19 WM_VARIANCE_PCT2 Signed Number(4,0) DECIMAL(3) NOT NULL Cost Variance %
20 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr
21 DESCRSHORT Character(10) VARCHAR2(10) NOT NULL Short Description
22 DESCRSHORT2 Character(10) VARCHAR2(10) NOT NULL Short Description