VIEW: APPS.FA_HR_RETIREMENT_HEADERS_V

Source

View Text - Preformatted

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

View Text - HTML Formatted

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