View: CSI_IAH_DETAILS_V

Product:	CSI - Install Base
Description:	Instance Account History Details View.
Implementation/DBA Data:	APPS.CSI_IAH_DETAILS_V

View Text

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 (+)

Columns