VIEW: APPS.FA_HIERARCHY_BATCH_HEADER_V

Source

View Text - Preformatted

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'

View Text - HTML Formatted

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'