VIEW: APPS.CSI_IAH_DETAILS_V

Source

View Text - Preformatted

SELECT CIAH.INSTANCE_ASSET_HISTORY_ID, CIAH.INSTANCE_ASSET_ID, CIAH.TRANSACTION_ID, CIA.INSTANCE_ID, CIAH.OLD_INSTANCE_ID, CIAH.NEW_INSTANCE_ID, CIAH.OLD_FA_ASSET_ID, CIAH.NEW_FA_ASSET_ID, CIAH.OLD_ASSET_QUANTITY, CIAH.NEW_ASSET_QUANTITY, CIAH.OLD_FA_BOOK_TYPE_CODE, CIAH.NEW_FA_BOOK_TYPE_CODE, CIAH.OLD_FA_LOCATION_ID, CIAH.NEW_FA_LOCATION_ID, CIAH.OLD_UPDATE_STATUS, CIAH.NEW_UPDATE_STATUS, CIAH.FULL_DUMP_FLAG, CIAH.CREATED_BY, CIAH.CREATION_DATE, CIAH.LAST_UPDATED_BY, CIAH.LAST_UPDATE_DATE, CIAH.LAST_UPDATE_LOGIN, CIAH.OBJECT_VERSION_NUMBER, CIAH.OLD_ACTIVE_START_DATE, CIAH.NEW_ACTIVE_START_DATE, CIAH.OLD_ACTIVE_END_DATE, CIAH.NEW_ACTIVE_END_DATE, OAD.ASSET_NUMBER OLD_ASSET_NUMBER, OAD.TAG_NUMBER OLD_TAG_NUMBER, OAD.SERIAL_NUMBER OLD_SERIAL_NUMBER, OCA.SEGMENT1 OLD_MAJOR_CATEGORY, OCA.SEGMENT2 OLD_SUB_CATEGORY, NAD.ASSET_NUMBER NEW_ASSET_NUMBER, NAD.TAG_NUMBER NEW_TAG_NUMBER, NAD.SERIAL_NUMBER NEW_SERIAL_NUMBER, NCA.SEGMENT1 NEW_MAJOR_CATEGORY, NCA.SEGMENT2 NEW_SUB_CATEGORY FROM CSI_I_ASSETS_H CIAH, CSI_I_ASSETS CIA, FA_ADDITIONS OAD, FA_CATEGORIES_B OCA, FA_ADDITIONS NAD, FA_CATEGORIES_B NCA WHERE CIAH.INSTANCE_ASSET_ID = CIA.INSTANCE_ASSET_ID AND CIAH.OLD_FA_ASSET_ID = OAD.ASSET_ID (+) AND OAD.ASSET_CATEGORY_ID = OCA.CATEGORY_ID (+) AND CIAH.NEW_FA_ASSET_ID = NAD.ASSET_ID (+) AND NAD.ASSET_CATEGORY_ID = NCA.CATEGORY_ID (+)

View Text - HTML Formatted

SELECT CIAH.INSTANCE_ASSET_HISTORY_ID
, CIAH.INSTANCE_ASSET_ID
, CIAH.TRANSACTION_ID
, CIA.INSTANCE_ID
, CIAH.OLD_INSTANCE_ID
, CIAH.NEW_INSTANCE_ID
, CIAH.OLD_FA_ASSET_ID
, CIAH.NEW_FA_ASSET_ID
, CIAH.OLD_ASSET_QUANTITY
, CIAH.NEW_ASSET_QUANTITY
, CIAH.OLD_FA_BOOK_TYPE_CODE
, CIAH.NEW_FA_BOOK_TYPE_CODE
, CIAH.OLD_FA_LOCATION_ID
, CIAH.NEW_FA_LOCATION_ID
, CIAH.OLD_UPDATE_STATUS
, CIAH.NEW_UPDATE_STATUS
, CIAH.FULL_DUMP_FLAG
, CIAH.CREATED_BY
, CIAH.CREATION_DATE
, CIAH.LAST_UPDATED_BY
, CIAH.LAST_UPDATE_DATE
, CIAH.LAST_UPDATE_LOGIN
, CIAH.OBJECT_VERSION_NUMBER
, CIAH.OLD_ACTIVE_START_DATE
, CIAH.NEW_ACTIVE_START_DATE
, CIAH.OLD_ACTIVE_END_DATE
, CIAH.NEW_ACTIVE_END_DATE
, OAD.ASSET_NUMBER OLD_ASSET_NUMBER
, OAD.TAG_NUMBER OLD_TAG_NUMBER
, OAD.SERIAL_NUMBER OLD_SERIAL_NUMBER
, OCA.SEGMENT1 OLD_MAJOR_CATEGORY
, OCA.SEGMENT2 OLD_SUB_CATEGORY
, NAD.ASSET_NUMBER NEW_ASSET_NUMBER
, NAD.TAG_NUMBER NEW_TAG_NUMBER
, NAD.SERIAL_NUMBER NEW_SERIAL_NUMBER
, NCA.SEGMENT1 NEW_MAJOR_CATEGORY
, NCA.SEGMENT2 NEW_SUB_CATEGORY
FROM CSI_I_ASSETS_H CIAH
, CSI_I_ASSETS CIA
, FA_ADDITIONS OAD
, FA_CATEGORIES_B OCA
, FA_ADDITIONS NAD
, FA_CATEGORIES_B NCA
WHERE CIAH.INSTANCE_ASSET_ID = CIA.INSTANCE_ASSET_ID
AND CIAH.OLD_FA_ASSET_ID = OAD.ASSET_ID (+)
AND OAD.ASSET_CATEGORY_ID = OCA.CATEGORY_ID (+)
AND CIAH.NEW_FA_ASSET_ID = NAD.ASSET_ID (+)
AND NAD.ASSET_CATEGORY_ID = NCA.CATEGORY_ID (+)