View: FA_MUPD_V

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

View Text

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

Columns