View: FA_RETIREMENT_REQUESTS_V

Product:	OFA - Assets
Description:	This view displays Mass Retirements and its effect on the performed retirement transaction
Implementation/DBA Data:	APPS.FA_RETIREMENT_REQUESTS_V

View Text

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

Columns