WM_ASSETCMP2_VW

(SQL View)
 Index Back

Child Work Order View

Child Work Order View

SELECT B.BUSINESS_UNIT , B.COMPONENT_OF_ID , B.DESCR , A.STATUS_CD , B.ASSET_ID , B.ASSET_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 , A.BUSINESS_UNIT , A.WO_ID FROM PS_WM_WO_TSK A , PS_ASSET B , XLATTABLE_VW D , PS_WM_STATUS_HDR G WHERE A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.ASSET_ID AND 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.ASSET_ID , B.DESCR , A.STATUS_CD , B.ASSET_ID ,E.XLATSHORTNAME %Concat '-' %Concat B.ASSET_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_TLS , A.ACTL_COST_PO , A.ACTL_COST_LBR + A.ACTL_COST_TLS + A.ACTL_COST_MAT + A.ACTL_COST_PO , A.CURRENCY_CD , 'N' , A.LAST_UPDATE_DTTM , G.DESCR , A.BUSINESS_UNIT , A.WO_ID FROM PS_WM_WO_TSK A , PS_ASSET B , XLATTABLE_VW E , PS_WM_STATUS_HDR G WHERE A.BUSINESS_UNIT_AM = B.BUSINESS_UNIT AND A.ASSET_ID = B.COMPONENT_OF_ID AND A.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_AM Character(5) VARCHAR2(5) NOT NULL AM Business Unit
2 COMPONENT_OF_ID Character(12) VARCHAR2(12) NOT NULL Component of Asset
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 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification
6 DESCR Character(30) VARCHAR2(30) NOT NULL Description
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
21 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
22 WO_ID Character(10) VARCHAR2(10) NOT NULL Work Order Identification