VIEW: APPS.FA_HR_RETIREMENT_DETAILS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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