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: APPS.CN_COLUMN_MAPS_V

Object Details

Object Name:	CN_COLUMN_MAPS_V
Object Type:	VIEW
Owner:	APPS
Subobject Name:
Status:	VALID

* Warning: Oracle Internal Use Only *

Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.

View Type

Internal

[View Source]

Columns

Name	Datatype	Length	Comments
ROW_ID	ROWID	(10)
COLUMN_MAP_ID	NUMBER	(15)
TABLE_MAP_ID	NUMBER	(15)
DESTINATION_COLUMN_ID	NUMBER	(15)
CALC_EXT_TABLE_ID	NUMBER	(15)
EXPRESSION	VARCHAR2	(1900)
EDITABLE	VARCHAR2	(1)
MODIFIED	VARCHAR2	(1)
UPDATE_CLAUSE	VARCHAR2	(1900)
LAST_UPDATE_DATE	DATE		Standard Who column - date when a user last updated this row.
LAST_UPDATED_BY	NUMBER	(15)	Standard who column - user who last updated this row (foreign key to FND_USER.USER_ID).
LAST_UPDATE_LOGIN	NUMBER	(15)	Standard who column - operating system login of user who last updated this row (foreign key to FND_LOGINS.LOGIN_ID).
CREATION_DATE	DATE		Standard who column - date when this row was created.
CREATED_BY	NUMBER	(15)	Standard who column - user who created this row (foreign key to FND_USER.USER_ID).
DESTINATION_COLUMN_NAME	VARCHAR2	(30)
DESTINATION_COLUMN_TYPE	VARCHAR2	(4)
DESTINATION_TABLE_ID	NUMBER	(15)
DESTINATION_TABLE_NAME	VARCHAR2	(30)
TEMPLATE_FLAG	VARCHAR2	(1)
SEED_CM_ID	NUMBER
SEED_EXPRESSION	VARCHAR2	(1900)
SEED_CALC_EXT_TABLE_ID	NUMBER
SEED_UPDATE_CLAUSE	VARCHAR2	(1900)
GROUP_BY_FLAG	VARCHAR2	(1)	Not currently used.
UNIQUE_FLAG	VARCHAR2	(1)	Not currently used.
OBJECT_VERSION_NUMBER	NUMBER	(15)
ORG_ID	NUMBER	(15)

Query Text

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


SELECT ROW_ID
,      COLUMN_MAP_ID
,      TABLE_MAP_ID
,      DESTINATION_COLUMN_ID
,      CALC_EXT_TABLE_ID
,      EXPRESSION
,      EDITABLE
,      MODIFIED
,      UPDATE_CLAUSE
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      DESTINATION_COLUMN_NAME
,      DESTINATION_COLUMN_TYPE
,      DESTINATION_TABLE_ID
,      DESTINATION_TABLE_NAME
,      TEMPLATE_FLAG
,      SEED_CM_ID
,      SEED_EXPRESSION
,      SEED_CALC_EXT_TABLE_ID
,      SEED_UPDATE_CLAUSE
,      GROUP_BY_FLAG
,      UNIQUE_FLAG
,      OBJECT_VERSION_NUMBER
,      ORG_ID
FROM APPS.CN_COLUMN_MAPS_V;

Dependencies

[top of page]

APPS.CN_COLUMN_MAPS_V references the following:

APPS: CN_COLUMN_MAPS; CN_COLUMN_MAPS_ALL; CN_OBJECTS

APPS.CN_COLUMN_MAPS_V is not referenced by any database object