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]

TABLE: CN.CN_TABLE_MAPS_ALL

Object Details

Object Name:	CN_TABLE_MAPS_ALL
Object Type:	TABLE
Owner:	CN
FND Design Data:	CN.CN_TABLE_MAPS_ALL
Subobject Name:
Status:	VALID

CN_TABLE_MAPS contains the mapping information between tables used in
the Sales Compensation system and the AR tables. These table maps are
used by the Collection code generator to improt transaction data into
the Sales compensation system from the AR system. Each column map in
the CN_COLUMN_MAPS table belongs to a table map.

Storage Details

Tablespace:	APPS_TS_SEED
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_TABLE_MAPS_U1	NORMAL	UNIQUE	APPS_TS_SEED	TABLE_MAP_ID ORG_ID
CN_TABLE_MAPS_U2	NORMAL	UNIQUE	APPS_TS_SEED	MAPPING_TYPE ORG_ID

Columns

Name	Datatype	Length	Mandatory	Comments
ORG_ID	NUMBER	(15)		Organization identifier
TABLE_MAP_ID	NUMBER	(15)	Yes	Primary key
MAPPING_TYPE	VARCHAR2	(4)	Yes	Type of mapping eg. event, collection, slice
SOURCE_TABLE_ID	NUMBER	(15)	Yes	Foreign key to CN_OBJECTS - the source table
DESTINATION_TABLE_ID	NUMBER	(15)	Yes	Foreign key to CN_OBJECTS - the destination table
MODULE_ID	NUMBER	(15)	Yes	Foreign key to CN_MODULES - the associated module
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).
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).
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).
DESCRIPTION	VARCHAR2	(1900)		Description
SEED_TABLE_MAP_ID	NUMBER	(15)		Seed table map ID
SOURCE_TBL_PKCOL_ID	NUMBER	(15)		Foreign Key (CN_OBJECTS) referencing the Primary Key column for the Line table of a Transaction Source.
DELETE_FLAG	VARCHAR2	(1)		'Y' if transations for this Transaction Source, which are filtered out during Collection, should be physically deleted from CN_COMM_LINES_API.
SOURCE_HDR_TBL_PKCOL_ID	NUMBER			Foreign Key (CN_OBJECTS) referencing the Primary Key column for the Header table of a Transaction Source.
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.
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.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	This column is used for locking purposes
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
FILTER	LONG	(0)		Not currently used

Query Text

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


SELECT ORG_ID
,      TABLE_MAP_ID
,      MAPPING_TYPE
,      SOURCE_TABLE_ID
,      DESTINATION_TABLE_ID
,      MODULE_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      SEED_TABLE_MAP_ID
,      SOURCE_TBL_PKCOL_ID
,      DELETE_FLAG
,      SOURCE_HDR_TBL_PKCOL_ID
,      SOURCE_TBL_HDR_FKCOL_ID
,      NOTIFY_WHERE
,      COLLECT_WHERE
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      FILTER
FROM CN.CN_TABLE_MAPS_ALL;

Dependencies

[top of page]

CN.CN_TABLE_MAPS_ALL does not reference any database object

CN.CN_TABLE_MAPS_ALL is referenced by following:

APPS: CN_TABLE_MAPS; CN_TABLE_MAPS_ALL