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_OBJ_COLUMNS_V

Object Details

Object Name:	CN_OBJ_COLUMNS_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
ROW_ID	ROWID	(10)		rowid of object in cn_objects.
COLUMN_ID	NUMBER	(15)	Yes	object_id in cn_objects.
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).
NAME	VARCHAR2	(30)	Yes	Column name.
DESCRIPTION	VARCHAR2	(1900)		Column description.
DEPENDENCY_MAP_COMPLETE	VARCHAR2	(1)	Yes	Not currently used. Set to N.
NEXT_SYNCHRONIZATION_DATE	DATE			Not currently used.
SYNCHRONIZATION_FREQUENCY	VARCHAR2	(30)		Not currently used.
STATUS	VARCHAR2	(1)	Yes	Object status. A= active. I=inactive.
REPOSITORY_ID	NUMBER	(15)	Yes	Repository that the object belongs to.
TABLE_ID	NUMBER	(15)		Object_id of the table which contains the column.
DATA_LENGTH	NUMBER	(15)		Column data length.
DATA_TYPE	VARCHAR2	(9)		Column data type.
NULLABLE	VARCHAR2	(1)		Column is nullable flag. Y= nullable.
PRIMARY_KEY	VARCHAR2	(1)		Flag: Column is a primary key. Y= primary key.
POSITION	NUMBER	(15)		Not currently used.
DIMENSION_ID	NUMBER	(15)		Dimension associated with the column.
DATA_SCALE	NUMBER	(15)		Not currently used.
COLUMN_TYPE	VARCHAR2	(4)		Not currently used.
USER_COLUMN_NAME	VARCHAR2	(1)		User column name flag. Y= user_name field is used.
SEED_COLUMN_ID	NUMBER	(15)		Seed data object_id.
OBJECT_TYPE	VARCHAR2	(15)	Yes	Type= COL.
USER_NAME	VARCHAR2	(30)		User column name given by the user.
FOREIGN_KEY	VARCHAR2	(1)		Flag: Column is a foreign key. Y= foriegn key.
CLASSIFICATION_COLUMN	VARCHAR2	(1)		Flag: classification column. Y= column can be used in calssification process.
CALC_FORMULA_FLAG	VARCHAR2	(1)		Used in Calculation Formula Flag
COLUMN_DATATYPE	VARCHAR2	(30)
VALUE_SET_ID	NUMBER	(15)
CUSTOM_CALL	VARCHAR2	(240)
ORG_ID	NUMBER	(15)

Query Text

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


SELECT ROW_ID
,      COLUMN_ID
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      NAME
,      DESCRIPTION
,      DEPENDENCY_MAP_COMPLETE
,      NEXT_SYNCHRONIZATION_DATE
,      SYNCHRONIZATION_FREQUENCY
,      STATUS
,      REPOSITORY_ID
,      TABLE_ID
,      DATA_LENGTH
,      DATA_TYPE
,      NULLABLE
,      PRIMARY_KEY
,      POSITION
,      DIMENSION_ID
,      DATA_SCALE
,      COLUMN_TYPE
,      USER_COLUMN_NAME
,      SEED_COLUMN_ID
,      OBJECT_TYPE
,      USER_NAME
,      FOREIGN_KEY
,      CLASSIFICATION_COLUMN
,      CALC_FORMULA_FLAG
,      COLUMN_DATATYPE
,      VALUE_SET_ID
,      CUSTOM_CALL
,      ORG_ID
FROM APPS.CN_OBJ_COLUMNS_V;