WM_CHILD_WO2_VW

(SQL View)
 Index Back

Child Work Order View

Child Work Order View

SELECT A.BUSINESS_UNIT , A.PARENT_WO_ID , A.DESCR254 , A.STATUS_CD , A.WO_ID , A.WO_ID , A.EST_COST_LBR , A.EST_COST_MAT , A.EST_COST_PO , A.EST_COST_TLS , (A.EST_COST_LBR + A.EST_COST_MAT + A.EST_COST_PO + A.EST_COST_TLS ) , 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 , 'Y' , A.LAST_UPDATE_DTTM , G.DESCR FROM PS_WM_WO_HDR A , XLATTABLE_VW D , PS_WM_STATUS_HDR G 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 ( D.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM XLATTABLE_VW B_ED WHERE D.FIELDNAME = B_ED.FIELDNAME AND D.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND D.FIELDNAME = 'WM_CHILD_WO_FLAG' AND D.FIELDVALUE = 'Y') UNION SELECT B.BUSINESS_UNIT , B.WO_ID , B.DESCR254 , B.STATUS_CD ,E.XLATSHORTNAME %Concat '-' %Concat B.WO_ID , B.WO_ID , B.EST_COST_LBR , B.EST_COST_MAT , B.EST_COST_PO , B.EST_COST_TLS , (B.EST_COST_LBR + B.EST_COST_MAT + B.EST_COST_PO + B.EST_COST_TLS ) , B.ACTL_COST_LBR , B.ACTL_COST_MAT , B.ACTL_COST_TLS , B.ACTL_COST_PO , B.ACTL_COST_LBR + B.ACTL_COST_TLS + B.ACTL_COST_MAT + B.ACTL_COST_PO , B.CURRENCY_CD , 'N' , B.LAST_UPDATE_DTTM , G.DESCR FROM PS_WM_WO_HDR B , XLATTABLE_VW E , PS_WM_STATUS_HDR G WHERE B.STATUS_CD = G.STATUS_CD AND G.SETID = ( SELECT F.SETID FROM PS_SET_CNTRL_REC F WHERE F.SETCNTRLVALUE = B.BUSINESS_UNIT AND F.RECNAME = 'WM_STATUS_HDR' ) AND ( E.EFFDT = ( SELECT MAX(B_ED.EFFDT) FROM XLATTABLE_VW B_ED WHERE E.FIELDNAME = B_ED.FIELDNAME AND E.FIELDVALUE = B_ED.FIELDVALUE AND B_ED.EFFDT <= %CurrentDateIn) AND E.FIELDNAME = 'WM_CHILD_WO_FLAG' AND E.FIELDVALUE = 'N' )

# 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 DESCR254 Character(254) VARCHAR2(254) NOT NULL Description of length 254
4 STATUS_CD Character(4) VARCHAR2(4) NOT NULL User defined Status Code
5 DESCR Character(30) VARCHAR2(30) NOT NULL Description
6 CHILD_WO_ID Character(10) VARCHAR2(10) NOT NULL Child Work Order ID
7 EST_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Labor Cost
8 EST_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Material Cost
9 EST_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Procurement costs for a work order
10 EST_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Estimated Tools Cost
11 TOTAL_EST_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Estimated Cost
12 ACTL_COST_LBR Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Labor Cost
13 ACTL_COST_MAT Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Cost
14 ACTL_COST_PO Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual procurement costs for a work order
15 ACTL_COST_TLS Signed Number(28,3) DECIMAL(26,3) NOT NULL Actual Tools Cost
16 TOTAL_ACTL_COST Signed Number(28,3) DECIMAL(26,3) NOT NULL Total Actual Cost
17 CURRENCY_CD Character(3) VARCHAR2(3) NOT NULL Currency Code
18 WM_CHILD_WO_FLAG Character(1) VARCHAR2(1) NOT NULL Child Flag
N=Parent
Y=Child
19 LAST_UPDATE_DTTM DateTime(26) TIMESTAMP Specifies the date and time of the last update to an entry. This field is maintained by PeopleSoft and is used in a variety of contexts.
20 DESCR1 Character(30) VARCHAR2(30) NOT NULL Descr