[Home] [Help] [Dependency Information]
Object Name: | CN_TABLE_MAPS_V |
---|---|
Object Type: | VIEW |
Owner: | APPS |
Subobject Name: | |
Status: | VALID |
Oracle Corporation does not support access to Oracle
applications data using this object, except from standard Oracle Applications programs.
Internal
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 |
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;
|
|
|