[Home] [Help] [Dependency Information]
Object Name: | CN_COLUMN_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 |
---|---|---|---|---|
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) |
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;
APPS.CN_COLUMN_MAPS_V is not referenced by any database object
|
|
|