Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_HR_RETIREMENT_DETAILS_V |
SELECT RD.BATCH_ID
, RD.CREATED_BY
, FU.USER_NAME
, RD.CREATION_DATE
, RD.LAST_UPDATED_BY
, RD.LAST_UPDATE_DATE
, RD.LAST_UPDATE_LOGIN
, RD.BOOK_TYPE_CODE
, RD.ASSET_ID
, FA.ASSET_NUMBER
, RD.DATE_PLACED_IN_SERVICE
, RD.CURRENT_COST
, RD.COST_RETIRED
, RD.CURRENT_UNITS
, RD.UNITS_RETIRED
, RD.PRORATE_PERCENT
, RD.RETIREMENT_CONVENTION_CODE
, RD.STATUS_CODE
, FL.MEANING /* STATUS_NAME */
, RD.REJECTION_REASON
, RD.RETIREMENT_ID
, RD.CONCURRENT_REQUEST_ID
, RD.PROCEEDS_OF_SALE
, RD.COST_OF_REMOVAL
FROM FA_HR_RETIREMENT_DETAILS RD
, FA_ADDITIONS FA
, FA_LOOKUPS FL
, FND_USER FU
WHERE RD.ASSET_ID = FA.ASSET_ID
AND ( RD.STATUS_CODE = FL.LOOKUP_CODE (+)
AND FL.LOOKUP_TYPE (+) = 'IFA_HR_STATUS_CODE')
AND RD.CREATED_BY = FU.USER_ID