[Home] [Help] [Dependency Information]
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.
Tablespace: | APPS_TS_TX_DATA |
---|---|
PCT Free: | 10 |
PCT Used: |
Index | Type | Uniqueness | Tablespace | Column |
---|---|---|---|---|
CN_OBJECTS_U1 | NORMAL | UNIQUE | APPS_TS_TX_IDX |
OBJECT_ID
ORG_ID |
CN_OBJECTS_N5 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX |
TABLE_ID
PRIMARY_KEY |
CN_OBJECTS_N6 | NORMAL | NONUNIQUE | APPS_TS_TX_IDX | OBJECT_TYPE |
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 |
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 | LONG | (0) | 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 |
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
FROM CN.CN_OBJECTS_ALL;
CN.CN_OBJECTS_ALL does not reference any database object
CN.CN_OBJECTS_ALL is referenced by following:
|
|
|