Product: | OFA - Assets |
---|---|
Description: | |
Implementation/DBA Data: | APPS.FA_HIERARCHY_BATCH_HEADER_V |
SELECT BH.BATCH_ID
, BH.BATCH_NUMBER
, BH.CREATED_BY
, FU.USER_NAME
, BH.CREATION_DATE
, BH.LAST_UPDATED_BY
, BH.LAST_UPDATE_DATE
, BH.LAST_UPDATE_LOGIN
, BH.BOOK_TYPE_CODE
, BH.STATUS_CODE
, FL.MEANING /*STATUS_NAME*/
, BH.EVENT_CODE
, FL1.MEANING /*EVENT_NAME*/
, BH.SOURCE_ENTITY_NAME
, FL2.MEANING /*SOURCE_ENTITY_MEANING*/
, BH.SOURCE_ENTITY_KEY_VALUE
, BH.SOURCE_ATTRIBUTE_NAME
, FL3.MEANING /*SOURCE_ATTRIBUTE_MEANING*/
, BH.SOURCE_ATTRIBUTE_OLD_ID
, BH.SOURCE_ATTRIBUTE_NEW_ID
, BH.DESCRIPTION
, BH.AMORTIZE_FLAG
, BH.AMORTIZATION_DATE
, BH.REJECTION_REASON_CODE
, BH.CONCURRENT_REQUEST_ID
, DECODE(BH.SOURCE_ATTRIBUTE_NAME
, 'PARENT'
, FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_OLD_ID))
, 'RULE_SET'
, FA_CUA_ASSET_WB_APIS_PKG.GET_RULE_SET_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_OLD_ID))
, 'CATEGORY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_OLD_ID))
, 'LEASE_NUMBER'
, FA_CUA_ASSET_WB_APIS_PKG.GET_LEASE_NUMBER(TO_NUMBER(BH.SOURCE_ATTRIBUTE_OLD_ID))
, 'SERIAL_NUMBER'
, BH.SOURCE_ATTRIBUTE_OLD_ID
, 'ASSET_KEY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_ASSET_KEY_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_OLD_ID))
, 'DISTRIBUTION'
, BH.SOURCE_ATTRIBUTE_OLD_ID
, 'LIFE_END_DATE'
, BH.SOURCE_ATTRIBUTE_OLD_ID
, 'NODE'
, FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_OLD_ID))
, BH.SOURCE_ATTRIBUTE_OLD_ID) SOURCE_ATTRIBUTE_OLD
, DECODE(BH.SOURCE_ATTRIBUTE_NAME
, 'PARENT'
, FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_NEW_ID))
, 'RULE_SET'
, FA_CUA_ASSET_WB_APIS_PKG.GET_RULE_SET_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_NEW_ID))
, 'CATEGORY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_NEW_ID))
, 'LEASE_NUMBER'
, FA_CUA_ASSET_WB_APIS_PKG.GET_LEASE_NUMBER(TO_NUMBER(BH.SOURCE_ATTRIBUTE_NEW_ID))
, 'SERIAL_NUMBER'
, BH.SOURCE_ATTRIBUTE_NEW_ID
, 'ASSET_KEY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_ASSET_KEY_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_NEW_ID))
, 'DISTRIBUTION'
, BH.SOURCE_ATTRIBUTE_NEW_ID
, 'LIFE_END_DATE'
, BH.SOURCE_ATTRIBUTE_NEW_ID
, 'NODE'
, FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_NAME(TO_NUMBER(BH.SOURCE_ATTRIBUTE_NEW_ID))
, BH.SOURCE_ATTRIBUTE_NEW_ID) SOURCE_ATTRIBUTE_NEW
, BH.TRANSACTION_NAME
, BH.ATTRIBUTE_CATEGORY
, BH.ATTRIBUTE1
, BH.ATTRIBUTE2
, BH.ATTRIBUTE3
, BH.ATTRIBUTE4
, BH.ATTRIBUTE5
, BH.ATTRIBUTE6
, BH.ATTRIBUTE7
, BH.ATTRIBUTE8
, BH.ATTRIBUTE9
, BH.ATTRIBUTE10
, BH.ATTRIBUTE11
, BH.ATTRIBUTE12
, BH.ATTRIBUTE13
, BH.ATTRIBUTE14
, BH.ATTRIBUTE15 FROM FA_MASS_UPDATE_BATCH_HEADERS BH
, FA_LOOKUPS FL
, FA_LOOKUPS FL1
, FA_LOOKUPS FL2
, FA_LOOKUPS FL3
, FND_USER FU
WHERE (BH.STATUS_CODE = FL.LOOKUP_CODE (+)
AND FL.LOOKUP_TYPE (+) = 'IFA_HR_STATUS_CODE') AND (BH.EVENT_CODE = FL1.LOOKUP_CODE (+)
AND FL1.LOOKUP_TYPE (+) = 'IFA_HR_EVENT_CODE') AND (BH.SOURCE_ENTITY_NAME = FL2.LOOKUP_CODE (+)
AND FL2.LOOKUP_TYPE (+) = 'IFA_HR_SRC_ENTITY_NAME') AND (BH.SOURCE_ATTRIBUTE_NAME = FL3.LOOKUP_CODE (+)
AND FL3.LOOKUP_TYPE (+) = 'IFA_HR_SRC_ATTRIBUTE_NAME') AND BH.CREATED_BY = FU.USER_ID
AND BH.EVENT_CODE <> 'HR_REINSTATEMENT'