DBA Data[Home] [Help]

VIEW: CSI.CSI_A_LOCATIONS#

Source

View Text - Preformatted

select ASSET_LOCATION_ID ASSET_LOCATION_ID, FA_LOCATION_ID FA_LOCATION_ID, LOCATION_TABLE LOCATION_TABLE, LOCATION_ID LOCATION_ID, ACTIVE_START_DATE ACTIVE_START_DATE, ACTIVE_END_DATE ACTIVE_END_DATE, 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 from "CSI"."CSI_A_LOCATIONS"
View Text - HTML Formatted

SELECT ASSET_LOCATION_ID ASSET_LOCATION_ID
, FA_LOCATION_ID FA_LOCATION_ID
, LOCATION_TABLE LOCATION_TABLE
, LOCATION_ID LOCATION_ID
, ACTIVE_START_DATE ACTIVE_START_DATE
, ACTIVE_END_DATE ACTIVE_END_DATE
, 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
FROM "CSI"."CSI_A_LOCATIONS"