eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

[Home] [Help]

VIEW: CSI.CSI_I_ASSETS_H#

Source

View Text - Preformatted


select INSTANCE_ASSET_HISTORY_ID INSTANCE_ASSET_HISTORY_ID, INSTANCE_ASSET_ID INSTANCE_ASSET_ID, TRANSACTION_ID TRANSACTION_ID, OLD_INSTANCE_ID OLD_INSTANCE_ID, NEW_INSTANCE_ID NEW_INSTANCE_ID, OLD_FA_ASSET_ID OLD_FA_ASSET_ID, NEW_FA_ASSET_ID NEW_FA_ASSET_ID, OLD_ASSET_QUANTITY OLD_ASSET_QUANTITY, NEW_ASSET_QUANTITY NEW_ASSET_QUANTITY, OLD_FA_BOOK_TYPE_CODE OLD_FA_BOOK_TYPE_CODE, NEW_FA_BOOK_TYPE_CODE NEW_FA_BOOK_TYPE_CODE, OLD_FA_LOCATION_ID OLD_FA_LOCATION_ID, NEW_FA_LOCATION_ID NEW_FA_LOCATION_ID, OLD_UPDATE_STATUS OLD_UPDATE_STATUS, NEW_UPDATE_STATUS NEW_UPDATE_STATUS, OLD_ACTIVE_START_DATE OLD_ACTIVE_START_DATE, NEW_ACTIVE_START_DATE NEW_ACTIVE_START_DATE, OLD_ACTIVE_END_DATE OLD_ACTIVE_END_DATE, NEW_ACTIVE_END_DATE NEW_ACTIVE_END_DATE, FULL_DUMP_FLAG FULL_DUMP_FLAG, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER, SECURITY_GROUP_ID SECURITY_GROUP_ID, MIGRATED_FLAG MIGRATED_FLAG, OLD_FA_SYNC_FLAG OLD_FA_SYNC_FLAG, NEW_FA_SYNC_FLAG NEW_FA_SYNC_FLAG, OLD_FA_MASS_ADDITION_ID OLD_FA_MASS_ADDITION_ID, NEW_FA_MASS_ADDITION_ID NEW_FA_MASS_ADDITION_ID, OLD_CREATION_COMPLETE_FLAG OLD_CREATION_COMPLETE_FLAG, NEW_CREATION_COMPLETE_FLAG NEW_CREATION_COMPLETE_FLAG from "CSI"."CSI_I_ASSETS_H"

View Text - HTML Formatted

SELECT INSTANCE_ASSET_HISTORY_ID INSTANCE_ASSET_HISTORY_ID
, INSTANCE_ASSET_ID INSTANCE_ASSET_ID
, TRANSACTION_ID TRANSACTION_ID
, OLD_INSTANCE_ID OLD_INSTANCE_ID
, NEW_INSTANCE_ID NEW_INSTANCE_ID
, OLD_FA_ASSET_ID OLD_FA_ASSET_ID
, NEW_FA_ASSET_ID NEW_FA_ASSET_ID
, OLD_ASSET_QUANTITY OLD_ASSET_QUANTITY
, NEW_ASSET_QUANTITY NEW_ASSET_QUANTITY
, OLD_FA_BOOK_TYPE_CODE OLD_FA_BOOK_TYPE_CODE
, NEW_FA_BOOK_TYPE_CODE NEW_FA_BOOK_TYPE_CODE
, OLD_FA_LOCATION_ID OLD_FA_LOCATION_ID
, NEW_FA_LOCATION_ID NEW_FA_LOCATION_ID
, OLD_UPDATE_STATUS OLD_UPDATE_STATUS
, NEW_UPDATE_STATUS NEW_UPDATE_STATUS
, OLD_ACTIVE_START_DATE OLD_ACTIVE_START_DATE
, NEW_ACTIVE_START_DATE NEW_ACTIVE_START_DATE
, OLD_ACTIVE_END_DATE OLD_ACTIVE_END_DATE
, NEW_ACTIVE_END_DATE NEW_ACTIVE_END_DATE
, FULL_DUMP_FLAG FULL_DUMP_FLAG
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, OBJECT_VERSION_NUMBER OBJECT_VERSION_NUMBER
, SECURITY_GROUP_ID SECURITY_GROUP_ID
, MIGRATED_FLAG MIGRATED_FLAG
, OLD_FA_SYNC_FLAG OLD_FA_SYNC_FLAG
, NEW_FA_SYNC_FLAG NEW_FA_SYNC_FLAG
, OLD_FA_MASS_ADDITION_ID OLD_FA_MASS_ADDITION_ID
, NEW_FA_MASS_ADDITION_ID NEW_FA_MASS_ADDITION_ID
, OLD_CREATION_COMPLETE_FLAG OLD_CREATION_COMPLETE_FLAG
, NEW_CREATION_COMPLETE_FLAG NEW_CREATION_COMPLETE_FLAG
FROM "CSI"."CSI_I_ASSETS_H"