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_TABLE_MAPS_V

Object Details

Object Name:	CN_TABLE_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	Mandatory	Comments
TABLE_MAP_ID	NUMBER	(15)	Yes
ORG_ID	NUMBER	(15)
MAPPING_TYPE	VARCHAR2	(4)	Yes
MODULE_ID	NUMBER	(15)	Yes
DESTINATION_TABLE_ID	NUMBER	(15)	Yes
SOURCE_TBL_HDR_FKCOL_ID	NUMBER			Foreign Key (CN_OBJECTS) referencing the Foreign Key column in the Line table of a Transaction Source, which links to the Primary Key of the Header table.
SOURCE_TBL_PKCOL_ID	NUMBER	(15)		Foreign Key (CN_OBJECTS) referencing the Primary Key column for the Line table of a Transaction Source.
SOURCE_HDR_TBL_PKCOL_ID	NUMBER			Foreign Key (CN_OBJECTS) referencing the Primary Key column for the Header table of a Transaction Source.
NOTIFY_WHERE	VARCHAR2	(1900)		User-defined join/restriction criteria appended to the WHERE clause of the Notification query of a Transaction Source.
COLLECT_WHERE	VARCHAR2	(1900)		User-defined join/restriction criteria appended to the WHERE clause of the Collection query of a Transaction Source.
DELETE_FLAG	VARCHAR2	(1)
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).
SOURCE_TABLE_ID	NUMBER	(15)	Yes
HEADER_TABLE_ID	NUMBER	(15)
SOURCE_TABLE_NAME	VARCHAR2	(30)	Yes
SOURCE_TABLE_ALIAS	VARCHAR2	(30)
HEADER_TABLE_NAME	VARCHAR2	(30)
HEADER_TABLE_ALIAS	VARCHAR2	(30)
LINEFK_NAME	VARCHAR2	(30)
LINEPK_NAME	VARCHAR2	(30)	Yes
HDRPK_NAME	VARCHAR2	(30)
DESTINATION_TABLE_NAME	VARCHAR2	(30)	Yes
DESTINATION_TABLE_ALIAS	VARCHAR2	(30)
MODULE_STATUS	VARCHAR2	(10)	Yes
EVENT_ID	NUMBER	(15)	Yes
EVENT_NAME	VARCHAR2	(80)	Yes
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes

Query Text

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


SELECT TABLE_MAP_ID
,      ORG_ID
,      MAPPING_TYPE
,      MODULE_ID
,      DESTINATION_TABLE_ID
,      SOURCE_TBL_HDR_FKCOL_ID
,      SOURCE_TBL_PKCOL_ID
,      SOURCE_HDR_TBL_PKCOL_ID
,      NOTIFY_WHERE
,      COLLECT_WHERE
,      DELETE_FLAG
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      LAST_UPDATE_LOGIN
,      CREATION_DATE
,      CREATED_BY
,      SOURCE_TABLE_ID
,      HEADER_TABLE_ID
,      SOURCE_TABLE_NAME
,      SOURCE_TABLE_ALIAS
,      HEADER_TABLE_NAME
,      HEADER_TABLE_ALIAS
,      LINEFK_NAME
,      LINEPK_NAME
,      HDRPK_NAME
,      DESTINATION_TABLE_NAME
,      DESTINATION_TABLE_ALIAS
,      MODULE_STATUS
,      EVENT_ID
,      EVENT_NAME
,      OBJECT_VERSION_NUMBER
FROM APPS.CN_TABLE_MAPS_V;

Dependencies

[top of page]

APPS.CN_TABLE_MAPS_V references the following:

APPS: CN_EVENTS; CN_MODULES; CN_OBJECTS; CN_TABLE_MAPS

APPS.CN_TABLE_MAPS_V is referenced by following:

APPS: CN_COLLECTION_CUSTOM_GEN - show dependent code; CN_COLLECTION_CUSTOM_GEN - show dependent code; CN_TABLE_MAPS_PVT - show dependent code