VIEW: APPS.FA_RETIREMENT_REQUESTS_V

Source

View Text - Preformatted

SELECT mr.book_type_code, ad.asset_number, th.transaction_type_code, ret.asset_id, ret.cost_retired, ret.status, ret.units, ret.cost_of_removal, ret.proceeds_of_sale, ret.gain_loss_amount, ret.nbv_retired, ret.retirement_prorate_convention, ret.date_effective, lu.meaning Retirement_Type, bk.group_asset_id, th.transaction_header_id, mr.mass_retirement_id, mr.project_id, mr.task_id , th.transaction_name Comments, dp.period_name Period_Entered, cp.period_name Period_Effective, ret.date_retired, ah.units Current_Units, bk.cost, ad.asset_number || ' - ' || ad.description Asset_Number_Desc From FA_MASS_RETIREMENTS mr, FA_BOOKS bk, FA_ADDITIONS ad, FA_TRANSACTION_HEADERS th, FA_LOOKUPS lu, FA_BOOK_CONTROLS bc, FA_CALENDAR_PERIODS cp, FA_DEPRN_PERIODS dp, FA_ASSET_HISTORY ah, FA_RETIREMENTS ret WHERE mr.mass_retirement_id = th.mass_transaction_id and ret.transaction_header_id_in = th.transaction_header_id and th.book_type_code = dp.book_type_code and th.date_effective between dp.period_open_date and nvl(dp.period_close_date,th.date_effective) and dp.book_type_code = bc.book_type_code and bc.deprn_calendar = cp.calendar_type and th.transaction_date_entered between cp.start_date and cp.end_date and bk.date_ineffective > ah.date_effective and bk.date_ineffective <= nvl(ah.date_ineffective, sysdate) and ah.asset_id = ret.asset_id and ret.retirement_type_code = lu.lookup_code(+) and lu.lookup_type(+) = 'RETIREMENT' and ret.asset_id = ad.asset_id and th.transaction_header_id = bk.transaction_header_id_out

View Text - HTML Formatted

SELECT MR.BOOK_TYPE_CODE
, AD.ASSET_NUMBER
, TH.TRANSACTION_TYPE_CODE
, RET.ASSET_ID
, RET.COST_RETIRED
, RET.STATUS
, RET.UNITS
, RET.COST_OF_REMOVAL
, RET.PROCEEDS_OF_SALE
, RET.GAIN_LOSS_AMOUNT
, RET.NBV_RETIRED
, RET.RETIREMENT_PRORATE_CONVENTION
, RET.DATE_EFFECTIVE
, LU.MEANING RETIREMENT_TYPE
, BK.GROUP_ASSET_ID
, TH.TRANSACTION_HEADER_ID
, MR.MASS_RETIREMENT_ID
, MR.PROJECT_ID
, MR.TASK_ID
, TH.TRANSACTION_NAME COMMENTS
, DP.PERIOD_NAME PERIOD_ENTERED
, CP.PERIOD_NAME PERIOD_EFFECTIVE
, RET.DATE_RETIRED
, AH.UNITS CURRENT_UNITS
, BK.COST
, AD.ASSET_NUMBER || ' - ' || AD.DESCRIPTION ASSET_NUMBER_DESC
FROM FA_MASS_RETIREMENTS MR
, FA_BOOKS BK
, FA_ADDITIONS AD
, FA_TRANSACTION_HEADERS TH
, FA_LOOKUPS LU
, FA_BOOK_CONTROLS BC
, FA_CALENDAR_PERIODS CP
, FA_DEPRN_PERIODS DP
, FA_ASSET_HISTORY AH
, FA_RETIREMENTS RET
WHERE MR.MASS_RETIREMENT_ID = TH.MASS_TRANSACTION_ID
AND RET.TRANSACTION_HEADER_ID_IN = TH.TRANSACTION_HEADER_ID
AND TH.BOOK_TYPE_CODE = DP.BOOK_TYPE_CODE
AND TH.DATE_EFFECTIVE BETWEEN DP.PERIOD_OPEN_DATE
AND NVL(DP.PERIOD_CLOSE_DATE
, TH.DATE_EFFECTIVE)
AND DP.BOOK_TYPE_CODE = BC.BOOK_TYPE_CODE
AND BC.DEPRN_CALENDAR = CP.CALENDAR_TYPE
AND TH.TRANSACTION_DATE_ENTERED BETWEEN CP.START_DATE
AND CP.END_DATE
AND BK.DATE_INEFFECTIVE > AH.DATE_EFFECTIVE
AND BK.DATE_INEFFECTIVE <= NVL(AH.DATE_INEFFECTIVE
, SYSDATE)
AND AH.ASSET_ID = RET.ASSET_ID
AND RET.RETIREMENT_TYPE_CODE = LU.LOOKUP_CODE(+)
AND LU.LOOKUP_TYPE(+) = 'RETIREMENT'
AND RET.ASSET_ID = AD.ASSET_ID
AND TH.TRANSACTION_HEADER_ID = BK.TRANSACTION_HEADER_ID_OUT