DBA Data[Home] [Help] [Dependency Information]

VIEW: CN.CN_COLUMN_MAPS_ALL#

Object Details
Object Name: CN_COLUMN_MAPS_ALL#
Object Type: VIEW
Owner: CN
Subobject Name:
Status: VALID

[View Source]

Columns
Name Datatype Length Mandatory Comments
COLUMN_MAP_ID NUMBER (15) Yes
DESTINATION_COLUMN_ID NUMBER (15) Yes
TABLE_MAP_ID NUMBER (15) Yes
LAST_UPDATE_DATE DATE

LAST_UPDATED_BY NUMBER (15)
CREATION_DATE DATE

CREATED_BY NUMBER (15)
LAST_UPDATE_LOGIN NUMBER (15)
SOURCE_COLUMN_ID NUMBER (15)
DRIVING_COLUMN_ID NUMBER (15)
EXPRESSION VARCHAR2 (1900)
AGGREGATE_FUNCTION VARCHAR2 (10)
SEED_COLUMN_MAP_ID NUMBER (15)
GROUP_BY_FLAG VARCHAR2 (1)
UNIQUE_FLAG VARCHAR2 (1)
ORG_ID NUMBER (15)
UPDATE_CLAUSE VARCHAR2 (1900)
MODIFIED VARCHAR2 (1) Yes
EDITABLE VARCHAR2 (1)
CALC_EXT_TABLE_ID NUMBER (15)
OBJECT_VERSION_NUMBER NUMBER (15) Yes
SECURITY_GROUP_ID NUMBER

ZD_EDITION_NAME VARCHAR2 (30) Yes
Query Text

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


SELECT COLUMN_MAP_ID
,      DESTINATION_COLUMN_ID
,      TABLE_MAP_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      SOURCE_COLUMN_ID
,      DRIVING_COLUMN_ID
,      EXPRESSION
,      AGGREGATE_FUNCTION
,      SEED_COLUMN_MAP_ID
,      GROUP_BY_FLAG
,      UNIQUE_FLAG
,      ORG_ID
,      UPDATE_CLAUSE
,      MODIFIED
,      EDITABLE
,      CALC_EXT_TABLE_ID
,      OBJECT_VERSION_NUMBER
,      SECURITY_GROUP_ID
,      ZD_EDITION_NAME
FROM CN.CN_COLUMN_MAPS_ALL#;

Dependencies

[top of page]

CN.CN_COLUMN_MAPS_ALL# references the following:

SchemaCN
TableCN_COLUMN_MAPS_ALL
CN.CN_COLUMN_MAPS_ALL# is referenced by following:

SchemaAPPS
SynonymCN_COLUMN_MAPS
SynonymCN_COLUMN_MAPS_ALL
TriggerCN_COLUMN_MAPS_ALL+