RET_TRADE_IN_VW

(SQL View)
 Index Back

Retired Assets - Traded In


SELECT a.business_unit , a.asset_id , SUM(a.TXN_PROCEEDS) , a.TXN_CURRENCY_CD FROM PS_RETIREMENT a , ps_bus_unit_tbl_am b WHERE a.disposal_code = 'T' AND a.trade_in_asset_id = ' ' AND A.RETIREMENT_STATUS = 'C' AND (A.BOOK = B.DEFAULT_BOOK OR (A.BOOK = ( SELECT MIN(C.BOOK) FROM PS_RETIREMENT C WHERE C.BUSINESS_UNIT = A.BUSINESS_UNIT AND C.ASSET_ID = A.ASSET_ID AND NOT EXISTS( SELECT 'X' FROM PS_RETIREMENT D WHERE D.BUSINESS_UNIT = A.BUSINESS_UNIT AND D.ASSET_ID = A.ASSET_ID AND D.BOOK = B.DEFAULT_BOOK ) ))) AND a.business_unit = b.business_unit GROUP BY a.business_unit, a.asset_id, a.TXN_cURRENCY_CD HAVING SUM(a.TXN_proceeds) <> 0

# PeopleSoft Field Name PeopleSoft Field Type Database Column Type Description
1 BUSINESS_UNIT Character(5) VARCHAR2(5) NOT NULL Business Unit
2 TRADE_IN_ASSET_ID Character(12) VARCHAR2(12) NOT NULL Trade In Asset
3 TRADE_IN_AMT Signed Number(28,3) DECIMAL(26,3) NOT NULL Trade In Amount
4 FROM_CUR Character(3) VARCHAR2(3) NOT NULL From Currency Code