VIEW: APPS.FA_MUPD_V

Source

View Text - Preformatted

SELECT 1, batch_id, ad.asset_number, FA_CUA_ASSET_WB_APIS_pkg.get_category_name(attribute_old_id), FA_CUA_ASSET_WB_APIS_pkg.get_category_name(attribute_new_id), status_code, rejection_reason, attribute_name ,concurrent_request_id from fa_mass_update_batch_details mubd, fa_additions ad WHERE mubd.attribute_name = 'CATEGORY' and mubd.asset_id = ad.asset_id union select 2, batch_id, ad.asset_number, FA_CUA_ASSET_WB_APIS_pkg.get_lease_number(attribute_old_id), FA_CUA_ASSET_WB_APIS_pkg.get_lease_number(attribute_new_id), status_code, rejection_reason ,attribute_name ,concurrent_request_id from fa_mass_update_batch_details mubd, fa_additions ad where mubd.attribute_name = 'LEASE_NUMBER' and mubd.asset_id = ad.asset_id union select 3, batch_id, ad.asset_number, attribute_old_id, attribute_new_id, status_code, rejection_reason, attribute_name ,concurrent_request_id from fa_mass_update_batch_details mubd, fa_additions ad where mubd.attribute_name = 'SERIAL_NUMBER' and mubd.asset_id = ad.asset_id union select 4, batch_id,ad.asset_number, FA_CUA_ASSET_WB_APIS_pkg.get_asset_key_name(attribute_old_id), FA_CUA_ASSET_WB_APIS_pkg.get_asset_key_name(attribute_new_id), status_code, rejection_reason, attribute_name ,concurrent_request_id from fa_mass_update_batch_details mubd, fa_additions ad where mubd.attribute_name = 'ASSET_KEY' and mubd.asset_id = ad.asset_id union select 5, batch_id,ad.asset_number, (attribute_old_id), (attribute_new_id), status_code, rejection_reason, attribute_name ,concurrent_request_id from fa_mass_update_batch_details mubd, fa_additions ad where mubd.attribute_name = 'DISTRIBUTION' and mubd.asset_id = ad.asset_id union select 6, batch_id, ad.asset_number, attribute_old_id old_value, attribute_new_id new_value, status_code, rejection_reason, attribute_name ,concurrent_request_id from fa_mass_update_batch_details mubd, fa_additions ad where mubd.attribute_name = 'LIFE_END_DATE' and mubd.asset_id = ad.asset_id

View Text - HTML Formatted

SELECT 1
, BATCH_ID
, AD.ASSET_NUMBER
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(ATTRIBUTE_OLD_ID)
, FA_CUA_ASSET_WB_APIS_PKG.GET_CATEGORY_NAME(ATTRIBUTE_NEW_ID)
, STATUS_CODE
, REJECTION_REASON
, ATTRIBUTE_NAME
, CONCURRENT_REQUEST_ID
FROM FA_MASS_UPDATE_BATCH_DETAILS MUBD
, FA_ADDITIONS AD
WHERE MUBD.ATTRIBUTE_NAME = 'CATEGORY'
AND MUBD.ASSET_ID = AD.ASSET_ID UNION SELECT 2
, BATCH_ID
, AD.ASSET_NUMBER
, FA_CUA_ASSET_WB_APIS_PKG.GET_LEASE_NUMBER(ATTRIBUTE_OLD_ID)
, FA_CUA_ASSET_WB_APIS_PKG.GET_LEASE_NUMBER(ATTRIBUTE_NEW_ID)
, STATUS_CODE
, REJECTION_REASON
, ATTRIBUTE_NAME
, CONCURRENT_REQUEST_ID
FROM FA_MASS_UPDATE_BATCH_DETAILS MUBD
, FA_ADDITIONS AD
WHERE MUBD.ATTRIBUTE_NAME = 'LEASE_NUMBER'
AND MUBD.ASSET_ID = AD.ASSET_ID UNION SELECT 3
, BATCH_ID
, AD.ASSET_NUMBER
, ATTRIBUTE_OLD_ID
, ATTRIBUTE_NEW_ID
, STATUS_CODE
, REJECTION_REASON
, ATTRIBUTE_NAME
, CONCURRENT_REQUEST_ID
FROM FA_MASS_UPDATE_BATCH_DETAILS MUBD
, FA_ADDITIONS AD
WHERE MUBD.ATTRIBUTE_NAME = 'SERIAL_NUMBER'
AND MUBD.ASSET_ID = AD.ASSET_ID UNION SELECT 4
, BATCH_ID
, AD.ASSET_NUMBER
, FA_CUA_ASSET_WB_APIS_PKG.GET_ASSET_KEY_NAME(ATTRIBUTE_OLD_ID)
, FA_CUA_ASSET_WB_APIS_PKG.GET_ASSET_KEY_NAME(ATTRIBUTE_NEW_ID)
, STATUS_CODE
, REJECTION_REASON
, ATTRIBUTE_NAME
, CONCURRENT_REQUEST_ID
FROM FA_MASS_UPDATE_BATCH_DETAILS MUBD
, FA_ADDITIONS AD
WHERE MUBD.ATTRIBUTE_NAME = 'ASSET_KEY'
AND MUBD.ASSET_ID = AD.ASSET_ID UNION SELECT 5
, BATCH_ID
, AD.ASSET_NUMBER
, (ATTRIBUTE_OLD_ID)
, (ATTRIBUTE_NEW_ID)
, STATUS_CODE
, REJECTION_REASON
, ATTRIBUTE_NAME
, CONCURRENT_REQUEST_ID
FROM FA_MASS_UPDATE_BATCH_DETAILS MUBD
, FA_ADDITIONS AD
WHERE MUBD.ATTRIBUTE_NAME = 'DISTRIBUTION'
AND MUBD.ASSET_ID = AD.ASSET_ID UNION SELECT 6
, BATCH_ID
, AD.ASSET_NUMBER
, ATTRIBUTE_OLD_ID OLD_VALUE
, ATTRIBUTE_NEW_ID NEW_VALUE
, STATUS_CODE
, REJECTION_REASON
, ATTRIBUTE_NAME
, CONCURRENT_REQUEST_ID
FROM FA_MASS_UPDATE_BATCH_DETAILS MUBD
, FA_ADDITIONS AD
WHERE MUBD.ATTRIBUTE_NAME = 'LIFE_END_DATE'
AND MUBD.ASSET_ID = AD.ASSET_ID