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.

DBA Data [Home] [Help] [Dependency Information]

VIEW: EC.ECE_INTERFACE_COLS_UPG#

Object Details

Object Name:	ECE_INTERFACE_COLS_UPG#
Object Type:	VIEW
Owner:	EC
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length	Mandatory
STAGING_COLUMN	VARCHAR2	(50)
INTERFACE_COLUMN_ID	NUMBER		Yes
INTERFACE_TABLE_ID	NUMBER
INTERFACE_COLUMN_NAME	VARCHAR2	(50)
BASE_TABLE_NAME	VARCHAR2	(50)
BASE_COLUMN_NAME	VARCHAR2	(50)
TABLE_NAME	VARCHAR2	(50)
COLUMN_NAME	VARCHAR2	(50)
RECORD_NUMBER	NUMBER
POSITION	NUMBER
WIDTH	NUMBER
CONVERSION_SEQUENCE	NUMBER
DATA_TYPE	VARCHAR2	(20)
CONVERSION_GROUP_ID	NUMBER
XREF_CATEGORY_ALLOWED	VARCHAR2	(1)
XREF_CATEGORY_ID	NUMBER
XREF_KEY1_SOURCE_COLUMN	VARCHAR2	(30)
XREF_KEY2_SOURCE_COLUMN	VARCHAR2	(30)
XREF_KEY3_SOURCE_COLUMN	VARCHAR2	(30)
XREF_KEY4_SOURCE_COLUMN	VARCHAR2	(30)
XREF_KEY5_SOURCE_COLUMN	VARCHAR2	(30)
RECORD_LAYOUT_CODE	VARCHAR2	(30)
RECORD_LAYOUT_QUALIFIER	VARCHAR2	(30)
DATA_LOC_ID	NUMBER
CREATED_BY	NUMBER	(15)	Yes
CREATION_DATE	DATE		Yes
LAST_UPDATE_LOGIN	NUMBER	(15)
LAST_UPDATE_DATE	DATE		Yes
LAST_UPDATED_BY	NUMBER	(15)	Yes
REQUEST_ID	NUMBER
PROGRAM_APPLICATION_ID	NUMBER
PROGRAM_ID	NUMBER
PROGRAM_UPDATE_DATE	DATE
EXTERNAL_LEVEL	NUMBER	(15)
MAP_ID	NUMBER	(15)
ELEMENT_TAG_NAME	VARCHAR2	(80)

Query Text

Cut, paste (and edit) the following text to query this object:


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

Dependencies

[top of page]

EC.ECE_INTERFACE_COLS_UPG# references the following:

EC: ECE_INTERFACE_COLS_UPG

EC.ECE_INTERFACE_COLS_UPG# is referenced by following:

APPS: ECE_INTERFACE_COLS_UPG