Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_HR_RETIREMENT_HEADERS_V |
SELECT RH.BATCH_ID
, RH.CREATED_BY
, FU.USER_NAME
, RH.CREATION_DATE
, RH.LAST_UPDATED_BY
, RH.LAST_UPDATE_DATE
, RH.LAST_UPDATE_LOGIN
, RH.BOOK_TYPE_CODE
, RH.STATUS_CODE
, FL.MEANING
, RH.EVENT_CODE
, AH.NAME
, RH.ASSET_HIERARCHY_ID
, RH.REJECTION_REASON_CODE
, RH.RETIREMENT_METHOD
, RH.RETIREMENT_TYPE_CODE
, FL2.MEANING
, RH.PRORATE_BY
, RH.RETIRE_BY
, RH.RETIREMENT_AMOUNT
, RH.RETIREMENT_PERCENT
, RH.RETIRE_DATE
, RH.ALLOW_PARTIAL_RETIRE_FLAG
, RH.RETIRE_UNITS_FLAG
, RH.CONCURRENT_REQUEST_ID
, RH.TRANSACTION_NAME
, RH.ATTRIBUTE_CATEGORY
, RH.ATTRIBUTE1
, RH.ATTRIBUTE2
, RH.ATTRIBUTE3
, RH.ATTRIBUTE4
, RH.ATTRIBUTE5
, RH.ATTRIBUTE6
, RH.ATTRIBUTE7
, RH.ATTRIBUTE8
, RH.ATTRIBUTE9
, RH.ATTRIBUTE10
, RH.ATTRIBUTE11
, RH.ATTRIBUTE12
, RH.ATTRIBUTE13
, RH.ATTRIBUTE14
, RH.ATTRIBUTE15
, RH.TH_ATTRIBUTE_CATEGORY
, RH.TH_ATTRIBUTE1
, RH.TH_ATTRIBUTE2
, RH.TH_ATTRIBUTE3
, RH.TH_ATTRIBUTE4
, RH.TH_ATTRIBUTE5
, RH.TH_ATTRIBUTE6
, RH.TH_ATTRIBUTE7
, RH.TH_ATTRIBUTE8
, RH.TH_ATTRIBUTE9
, RH.TH_ATTRIBUTE10
, RH.TH_ATTRIBUTE11
, RH.TH_ATTRIBUTE12
, RH.TH_ATTRIBUTE13
, RH.TH_ATTRIBUTE14
, RH.TH_ATTRIBUTE15
, RH.PROCEEDS_OF_SALE
, RH.COST_OF_REMOVAL
FROM FA_HR_RETIREMENT_HEADERS RH
, FA_ASSET_HIERARCHY AH
, FA_LOOKUPS FL
, FA_LOOKUPS FL2
, FND_USER FU
WHERE AH.ASSET_HIERARCHY_ID = RH.ASSET_HIERARCHY_ID
AND ( RH.STATUS_CODE = FL.LOOKUP_CODE (+)
AND FL.LOOKUP_TYPE (+) = 'IFA_HR_STATUS_CODE')
AND ( RH.RETIREMENT_TYPE_CODE = FL2.LOOKUP_CODE (+)
AND FL2.LOOKUP_TYPE (+) = 'RETIREMENT')
AND RH.CREATED_BY = FU.USER_ID