ASSET_COMRET_VW

(SQL View)
 Index Back

Asset Composite Vw For Mass Ch

Asset Composite Vw RET For Mass Ch

SELECT A.BUSINESS_UNIT , A.ASSET_ID FROM PS_ASSET A , PS_ASSET B , PS_ASSET_ACQ_DET C , PS_RETIREMENT D WHERE A.BUSINESS_UNIT = B.BUSINESS_UNIT AND A.BUSINESS_UNIT = C.BUSINESS_UNIT AND A.ASSET_ID = B.COMPOSITE_ID AND A.BUSINESS_UNIT = D.BUSINESS_UNIT AND A.ASSET_ID = D.ASSET_ID AND A.COMPOSITE_SW = 'Y' AND B.ASSET_ID = C.ASSET_ID

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 ASSET_ID Character(12) VARCHAR2(12) NOT NULL Asset Identification