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: EC.ECE_INTERFACE_COLS_UPG#

Source

View Text - Preformatted


select STAGING_COLUMN STAGING_COLUMN, INTERFACE_COLUMN_ID INTERFACE_COLUMN_ID, INTERFACE_TABLE_ID INTERFACE_TABLE_ID, INTERFACE_COLUMN_NAME INTERFACE_COLUMN_NAME, BASE_TABLE_NAME BASE_TABLE_NAME, BASE_COLUMN_NAME BASE_COLUMN_NAME, TABLE_NAME TABLE_NAME, COLUMN_NAME COLUMN_NAME, RECORD_NUMBER RECORD_NUMBER, POSITION POSITION, WIDTH WIDTH, CONVERSION_SEQUENCE CONVERSION_SEQUENCE, DATA_TYPE DATA_TYPE, CONVERSION_GROUP_ID CONVERSION_GROUP_ID, XREF_CATEGORY_ALLOWED XREF_CATEGORY_ALLOWED, XREF_CATEGORY_ID XREF_CATEGORY_ID, XREF_KEY1_SOURCE_COLUMN XREF_KEY1_SOURCE_COLUMN, XREF_KEY2_SOURCE_COLUMN XREF_KEY2_SOURCE_COLUMN, XREF_KEY3_SOURCE_COLUMN XREF_KEY3_SOURCE_COLUMN, XREF_KEY4_SOURCE_COLUMN XREF_KEY4_SOURCE_COLUMN, XREF_KEY5_SOURCE_COLUMN XREF_KEY5_SOURCE_COLUMN, RECORD_LAYOUT_CODE RECORD_LAYOUT_CODE, RECORD_LAYOUT_QUALIFIER RECORD_LAYOUT_QUALIFIER, DATA_LOC_ID DATA_LOC_ID, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, REQUEST_ID REQUEST_ID, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID, PROGRAM_ID PROGRAM_ID, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE, EXTERNAL_LEVEL EXTERNAL_LEVEL, MAP_ID MAP_ID, ELEMENT_TAG_NAME ELEMENT_TAG_NAME from "EC"."ECE_INTERFACE_COLS_UPG"

View Text - HTML Formatted

SELECT STAGING_COLUMN STAGING_COLUMN
, INTERFACE_COLUMN_ID INTERFACE_COLUMN_ID
, INTERFACE_TABLE_ID INTERFACE_TABLE_ID
, INTERFACE_COLUMN_NAME INTERFACE_COLUMN_NAME
, BASE_TABLE_NAME BASE_TABLE_NAME
, BASE_COLUMN_NAME BASE_COLUMN_NAME
, TABLE_NAME TABLE_NAME
, COLUMN_NAME COLUMN_NAME
, RECORD_NUMBER RECORD_NUMBER
, POSITION POSITION
, WIDTH WIDTH
, CONVERSION_SEQUENCE CONVERSION_SEQUENCE
, DATA_TYPE DATA_TYPE
, CONVERSION_GROUP_ID CONVERSION_GROUP_ID
, XREF_CATEGORY_ALLOWED XREF_CATEGORY_ALLOWED
, XREF_CATEGORY_ID XREF_CATEGORY_ID
, XREF_KEY1_SOURCE_COLUMN XREF_KEY1_SOURCE_COLUMN
, XREF_KEY2_SOURCE_COLUMN XREF_KEY2_SOURCE_COLUMN
, XREF_KEY3_SOURCE_COLUMN XREF_KEY3_SOURCE_COLUMN
, XREF_KEY4_SOURCE_COLUMN XREF_KEY4_SOURCE_COLUMN
, XREF_KEY5_SOURCE_COLUMN XREF_KEY5_SOURCE_COLUMN
, RECORD_LAYOUT_CODE RECORD_LAYOUT_CODE
, RECORD_LAYOUT_QUALIFIER RECORD_LAYOUT_QUALIFIER
, DATA_LOC_ID DATA_LOC_ID
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, REQUEST_ID REQUEST_ID
, PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, PROGRAM_ID PROGRAM_ID
, PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, EXTERNAL_LEVEL EXTERNAL_LEVEL
, MAP_ID MAP_ID
, ELEMENT_TAG_NAME ELEMENT_TAG_NAME
FROM "EC"."ECE_INTERFACE_COLS_UPG"