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_OBJECTS_ALL

Object Details

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

CN_OBJECTS contains information about various system objects used in
the Sales Compensation system. These objects are tables, columns,
packages, procedures, triggers, and sequences.

Storage Details

Tablespace:	APPS_TS_TX_DATA
PCT Free:	10
PCT Used:

Indexes

Index	Type	Uniqueness	Tablespace	Column
CN_OBJECTS_U1	NORMAL	UNIQUE	APPS_TS_TX_IDX	OBJECT_ID ORG_ID ZD_EDITION_NAME
SYS_IL0000031606C00062$$	LOB	UNIQUE	APPS_TS_TX_DATA
CN_OBJECTS_N5	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TABLE_ID PRIMARY_KEY
CN_OBJECTS_N6	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	OBJECT_TYPE TABLE_ID ORG_ID
CN_OBJECTS_N7	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	NAME TABLE_ID
CN_OBJECTS_N8	NORMAL	NONUNIQUE	APPS_TS_TX_IDX	TABLE_ID ORG_ID CALC_FORMULA_FLAG

Columns

Name	Datatype	Length	Mandatory	Comments
OBJECT_ID	NUMBER	(15)	Yes	Primary key
DEPENDENCY_MAP_COMPLETE	VARCHAR2	(1)	Yes	Not currently used. Set to N.
NAME	VARCHAR2	(30)	Yes	Object name
OBJECT_TYPE	VARCHAR2	(15)	Yes	Object type: TBL= table, COL= column, SEQ= sequence, TRG= trigger, PKB= package body, PKS= package spec, PRC= procedure
REPOSITORY_ID	NUMBER	(15)	Yes	Foriegn key to CN_REPOSITORIES. Repository that the object belongs to.
OBJECT_STATUS	VARCHAR2	(1)	Yes	Object status. A= active. I= inactive.
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)		Object description
NEXT_SYNCHRONIZATION_DATE	DATE			Not currently used.
SYNCHRONIZATION_FREQUENCY	VARCHAR2	(30)		Not currently used.
DATA_LENGTH	NUMBER	(15)		For a column. Data length.
DATA_TYPE	VARCHAR2	(9)		For a column. Data type.
NULLABLE	VARCHAR2	(1)		Column is nullable.
PRIMARY_KEY	VARCHAR2	(1)		Primary key flag. If 'Y' then column is a primary key.
POSITION	NUMBER	(15)		Position.
DIMENSION_ID	NUMBER	(15)		Object belongs to this dimension.
DATA_SCALE	NUMBER	(15)		Data scale.
COLUMN_TYPE	VARCHAR2	(4)		Column type. Not currently used.
TABLE_ID	NUMBER	(15)		Table ID of the table that contains the column.
UNIQUE_FLAG	VARCHAR2	(1)		Unique flag for an index.
PACKAGE_TYPE	VARCHAR2	(4)		Package type. COL= collection, CLS= classification, INV= invoice, PMT= payment, GBK= giveback, CBK= clawback, WO= writeoff.
PACKAGE_SPECIFICATION_ID	NUMBER	(15)		Object_id of the specification for a package.
PARAMETER_LIST	VARCHAR2	(1900)		Parameter list that is input to a package.
RETURN_TYPE	VARCHAR2	(9)		Return data type for a function.
PROCEDURE_TYPE	VARCHAR2	(1)		Procedure type. P= procedure. F= function.
PACKAGE_ID	NUMBER	(15)		Object ID of the package that contains a procedure.
START_VALUE	NUMBER	(15)		Start value for a sequence.
INCREMENT_VALUE	NUMBER	(15)		Increment value for a sequence.
ALIAS	VARCHAR2	(30)		Alias for a table.
TABLE_LEVEL	VARCHAR2	(1)		Table level. H= header, L= line, S= sales line, N= none.
TABLE_TYPE	VARCHAR2	(1)		Table type. T= table, V= view.
WHEN_CLAUSE	VARCHAR2	(255)		Trigger when clause.
TRIGGERING_EVENT	VARCHAR2	(1)		Event that causes a trigger to fire.
EVENT_ID	NUMBER	(15)		Event associated with an object.
PUBLIC_FLAG	VARCHAR2	(1)		Procedure is public.
CHILD_FLAG	VARCHAR2	(1)		Not currently used.
FOR_EACH_ROW	VARCHAR2	(1)		Trigger for each row statement.
TRIGGER_TYPE	VARCHAR2	(1)		Trigger type.
USER_COLUMN_NAME	VARCHAR2	(1)		Flag for user_name field. Y= user_name field in use.
SEED_OBJECT_ID	NUMBER	(15)		Seed data object id.
PRIMARY_KEY_COLUMN_ID	NUMBER	(15)		For a table. object_id of the primary key column.
USER_NAME_COLUMN_ID	NUMBER	(15)		For a column. object_id of the user_name column.
CONNECT_TO_USERNAME	VARCHAR2	(30)		For a dblink object. The connect username.
CONNECT_TO_PASSWORD	VARCHAR2	(30)		For a dblink object. The connect passwrod.
CONNECT_TO_HOST	VARCHAR2	(255)		For a dblink object. The connect host name.
USER_NAME	VARCHAR2	(30)		Column name assigned by the user. Used the in AR Mapping process.
SCHEMA	VARCHAR2	(30)		Schema that the object belongs to.
FOREIGN_KEY	VARCHAR2	(1)		Foreign key flag. If 'Y' then column is a foreign key.
CLASSIFICATION_COLUMN	VARCHAR2	(1)		Classification column flag. If 'Y' then column can be used in the Classification process.
CALC_FORMULA_FLAG	VARCHAR2	(1)		Used in Calculation Formula Flag default to 'N'
ORG_ID	NUMBER	(15)		Organization identifier
CALC_ELIGIBLE_FLAG	VARCHAR2	(1)		Eligibility for Calculation Formula Flag default to 'N'
COLUMN_DATATYPE	VARCHAR2	(30)		The datatype for the data that is stored in this column.
VALUE_SET_ID	NUMBER	(15)		Unique identifier for the valueset.
OBJECT_VALUE	VARCHAR2	(1900)		Object value
CUSTOM_CALL	VARCHAR2	(240)		Custom JSP call
SECURITY_GROUP_ID	NUMBER			Used in hosted environments
STATEMENT_TEXT	CLOB	(4000)		Statement text for a package or procedure. Not currently used.
OBJECT_VERSION_NUMBER	NUMBER	(15)	Yes	Used for Locking
DISPLAY_COLUMN	VARCHAR2	(1)		Display in Results column
ZD_EDITION_NAME	VARCHAR2	(30)	Yes

Query Text

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


SELECT OBJECT_ID
,      DEPENDENCY_MAP_COMPLETE
,      NAME
,      OBJECT_TYPE
,      REPOSITORY_ID
,      OBJECT_STATUS
,      LAST_UPDATE_DATE
,      LAST_UPDATED_BY
,      CREATION_DATE
,      CREATED_BY
,      LAST_UPDATE_LOGIN
,      DESCRIPTION
,      NEXT_SYNCHRONIZATION_DATE
,      SYNCHRONIZATION_FREQUENCY
,      DATA_LENGTH
,      DATA_TYPE
,      NULLABLE
,      PRIMARY_KEY
,      POSITION
,      DIMENSION_ID
,      DATA_SCALE
,      COLUMN_TYPE
,      TABLE_ID
,      UNIQUE_FLAG
,      PACKAGE_TYPE
,      PACKAGE_SPECIFICATION_ID
,      PARAMETER_LIST
,      RETURN_TYPE
,      PROCEDURE_TYPE
,      PACKAGE_ID
,      START_VALUE
,      INCREMENT_VALUE
,      ALIAS
,      TABLE_LEVEL
,      TABLE_TYPE
,      WHEN_CLAUSE
,      TRIGGERING_EVENT
,      EVENT_ID
,      PUBLIC_FLAG
,      CHILD_FLAG
,      FOR_EACH_ROW
,      TRIGGER_TYPE
,      USER_COLUMN_NAME
,      SEED_OBJECT_ID
,      PRIMARY_KEY_COLUMN_ID
,      USER_NAME_COLUMN_ID
,      CONNECT_TO_USERNAME
,      CONNECT_TO_PASSWORD
,      CONNECT_TO_HOST
,      USER_NAME
,      SCHEMA
,      FOREIGN_KEY
,      CLASSIFICATION_COLUMN
,      CALC_FORMULA_FLAG
,      ORG_ID
,      CALC_ELIGIBLE_FLAG
,      COLUMN_DATATYPE
,      VALUE_SET_ID
,      OBJECT_VALUE
,      CUSTOM_CALL
,      SECURITY_GROUP_ID
,      STATEMENT_TEXT
,      OBJECT_VERSION_NUMBER
,      DISPLAY_COLUMN
,      ZD_EDITION_NAME
FROM CN.CN_OBJECTS_ALL;

Dependencies

[top of page]

CN.CN_OBJECTS_ALL does not reference any database object

CN.CN_OBJECTS_ALL is referenced by following:

CN: CN_OBJECTS_ALL#