View: FA_HIERARCHY_BATCH_DETAILS_V

Product:	OFA - Assets
Description:
Implementation/DBA Data:	APPS.FA_HIERARCHY_BATCH_DETAILS_V

View Text

SELECT DECODE(BD.ATTRIBUTE_NAME
, 'CATEGORY'
, 1
, 'LEASE_NUMBER'
, 2
, 'SERIAL_NUMBER'
, 3
, 'ASSET_KEY'
, 4
, 'DISTRIBUTION'
, 5
, 'LIFE_END_DATE'
, 6)
, BD.BATCH_ID
, BD.BOOK_TYPE_CODE
, BD.ATTRIBUTE_NAME
, FL1.MEANING
, BD.ASSET_ID
, AD.ASSET_NUMBER
, BD.ATTRIBUTE_OLD_ID
, DECODE(BD.ATTRIBUTE_NAME
, 'CATEGORY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(TO_NUMBER(BD.ATTRIBUTE_OLD_ID))
, 'LEASE_NUMBER'
, FA_CUA_ASSET_WB_APIS_PKG.GET_LEASE_NUMBER(TO_NUMBER(BD.ATTRIBUTE_OLD_ID))
, 'SERIAL_NUMBER'
, BD.ATTRIBUTE_OLD_ID
, 'ASSET_KEY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_ASSET_KEY_NAME(TO_NUMBER(BD.ATTRIBUTE_OLD_ID))
, 'DISTRIBUTION'
, NULL
, 'LIFE_END_DATE'
, BD.ATTRIBUTE_OLD_ID)
, BD.ATTRIBUTE_NEW_ID
, DECODE(BD.ATTRIBUTE_NAME
, 'CATEGORY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(TO_NUMBER(BD.ATTRIBUTE_NEW_ID))
, 'LEASE_NUMBER'
, FA_CUA_ASSET_WB_APIS_PKG.GET_LEASE_NUMBER(TO_NUMBER(BD.ATTRIBUTE_NEW_ID))
, 'SERIAL_NUMBER'
, BD.ATTRIBUTE_NEW_ID
, 'ASSET_KEY'
, FA_CUA_ASSET_WB_APIS_PKG.GET_ASSET_KEY_NAME(TO_NUMBER(BD.ATTRIBUTE_NEW_ID))
, 'DISTRIBUTION'
, NULL
, 'LIFE_END_DATE'
, BD.ATTRIBUTE_NEW_ID)
, BD.DERIVED_FROM_ENTITY
, FL2.MEANING||DECODE(BD.DERIVED_FROM_ENTITY
, 'NODE'
, ':LEVEL-'||FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_LEVEL(BD.DERIVED_FROM_ENTITY_ID)
, 'NODE-P'
, ':LEVEL-'||FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_LEVEL(BD.DERIVED_FROM_ENTITY_ID)
, NULL)
, BD.DERIVED_FROM_ENTITY_ID
, DECODE(BD.DERIVED_FROM_ENTITY
, 'NODE'
, FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_NAME(BD.DERIVED_FROM_ENTITY_ID)
, 'NODE-P'
, FA_CUA_ASSET_WB_APIS_PKG.GET_NODE_NAME(BD.DERIVED_FROM_ENTITY_ID)
, 'CATEGORY-LIFE'
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(BD.DERIVED_FROM_ENTITY_ID)
, 'CATEGORY-LED'
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(BD.DERIVED_FROM_ENTITY_ID)
, 'LEASE'
, FA_CUA_ASSET_WB_APIS_PKG.GET_LEASE_NUMBER(BD.DERIVED_FROM_ENTITY_ID)
, 'ASSET'
, FA_CUA_ASSET_WB_APIS_PKG.GET_ASSET_NUMBER(BD.DERIVED_FROM_ENTITY_ID)
, NULL )
, BD.CREATED_BY
, BD.CREATION_DATE
, BD.LAST_UPDATED_BY
, BD.LAST_UPDATE_DATE
, BD.LAST_UPDATE_LOGIN
, BD.STATUS_CODE
, FL.MEANING
, BD.REJECTION_REASON
, BD.APPLY_FLAG
, BD.EFFECTIVE_DATE
, BD.FA_PERIOD_NAME
, BD.CONCURRENT_REQUEST_ID
, BD.PARENT_HIERARCHY_ID
FROM FA_MASS_UPDATE_BATCH_DETAILS BD
, FA_ADDITIONS AD
, FA_LOOKUPS FL
, FA_LOOKUPS FL1
, FA_LOOKUPS FL2
WHERE AD.ASSET_ID = BD.ASSET_ID
AND (BD.STATUS_CODE = FL.LOOKUP_CODE (+)
AND FL.LOOKUP_TYPE (+) = 'IFA_HR_STATUS_CODE')
AND (BD.ATTRIBUTE_NAME = FL1.LOOKUP_CODE (+)
AND FL1.LOOKUP_TYPE (+) = 'IFA_HR_SRC_ATTRIBUTE_NAME')
AND (BD.DERIVED_FROM_ENTITY = FL2.LOOKUP_CODE (+)
AND FL2.LOOKUP_TYPE (+) = 'IFA_HR_SRC_ENTITY_NAME')

Columns