[Home] [Help]
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
Name |
SEQ_NO |
BATCH_ID |
ASSET_NUMBER |
OLD_VALUE |
NEW_VALUE |
STATUS_CODE |
REJECTION_REASON |
ATTRIBUTE_NAME |
CONCURRENT_REQUEST_ID |