[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | CN_OBJECTS_ALL# |
|---|---|
| Object Type: | VIEW |
| Owner: | CN |
| Subobject Name: | |
| Status: | VALID |
| Name | Datatype | Length | Mandatory | Comments |
|---|---|---|---|---|
| OBJECT_ID | NUMBER | (15) | Yes | |
| DEPENDENCY_MAP_COMPLETE | VARCHAR2 | (1) | Yes | |
| NAME | VARCHAR2 | (30) | Yes | |
| OBJECT_TYPE | VARCHAR2 | (15) | Yes | |
| REPOSITORY_ID | NUMBER | (15) | Yes | |
| OBJECT_STATUS | VARCHAR2 | (1) | Yes | |
| LAST_UPDATE_DATE | DATE | |||
| LAST_UPDATED_BY | NUMBER | (15) | ||
| CREATION_DATE | DATE | |||
| CREATED_BY | NUMBER | (15) | ||
| LAST_UPDATE_LOGIN | NUMBER | (15) | ||
| DESCRIPTION | VARCHAR2 | (1900) | ||
| NEXT_SYNCHRONIZATION_DATE | DATE | |||
| SYNCHRONIZATION_FREQUENCY | VARCHAR2 | (30) | ||
| DATA_LENGTH | NUMBER | (15) | ||
| DATA_TYPE | VARCHAR2 | (9) | ||
| NULLABLE | VARCHAR2 | (1) | ||
| PRIMARY_KEY | VARCHAR2 | (1) | ||
| POSITION | NUMBER | (15) | ||
| DIMENSION_ID | NUMBER | (15) | ||
| DATA_SCALE | NUMBER | (15) | ||
| COLUMN_TYPE | VARCHAR2 | (4) | ||
| TABLE_ID | NUMBER | (15) | ||
| UNIQUE_FLAG | VARCHAR2 | (1) | ||
| PACKAGE_TYPE | VARCHAR2 | (4) | ||
| PACKAGE_SPECIFICATION_ID | NUMBER | (15) | ||
| PARAMETER_LIST | VARCHAR2 | (1900) | ||
| RETURN_TYPE | VARCHAR2 | (9) | ||
| PROCEDURE_TYPE | VARCHAR2 | (1) | ||
| PACKAGE_ID | NUMBER | (15) | ||
| START_VALUE | NUMBER | (15) | ||
| INCREMENT_VALUE | NUMBER | (15) | ||
| ALIAS | VARCHAR2 | (30) | ||
| TABLE_LEVEL | VARCHAR2 | (1) | ||
| TABLE_TYPE | VARCHAR2 | (1) | ||
| WHEN_CLAUSE | VARCHAR2 | (255) | ||
| TRIGGERING_EVENT | VARCHAR2 | (1) | ||
| EVENT_ID | NUMBER | (15) | ||
| PUBLIC_FLAG | VARCHAR2 | (1) | ||
| CHILD_FLAG | VARCHAR2 | (1) | ||
| FOR_EACH_ROW | VARCHAR2 | (1) | ||
| TRIGGER_TYPE | VARCHAR2 | (1) | ||
| USER_COLUMN_NAME | VARCHAR2 | (1) | ||
| SEED_OBJECT_ID | NUMBER | (15) | ||
| PRIMARY_KEY_COLUMN_ID | NUMBER | (15) | ||
| USER_NAME_COLUMN_ID | NUMBER | (15) | ||
| CONNECT_TO_USERNAME | VARCHAR2 | (30) | ||
| CONNECT_TO_PASSWORD | VARCHAR2 | (30) | ||
| CONNECT_TO_HOST | VARCHAR2 | (255) | ||
| USER_NAME | VARCHAR2 | (30) | ||
| SCHEMA | VARCHAR2 | (30) | ||
| FOREIGN_KEY | VARCHAR2 | (1) | ||
| CLASSIFICATION_COLUMN | VARCHAR2 | (1) | ||
| CALC_FORMULA_FLAG | VARCHAR2 | (1) | ||
| ORG_ID | NUMBER | (15) | ||
| CALC_ELIGIBLE_FLAG | VARCHAR2 | (1) | ||
| COLUMN_DATATYPE | VARCHAR2 | (30) | ||
| VALUE_SET_ID | NUMBER | (15) | ||
| OBJECT_VALUE | VARCHAR2 | (1900) | ||
| CUSTOM_CALL | VARCHAR2 | (240) | ||
| SECURITY_GROUP_ID | NUMBER | |||
| STATEMENT_TEXT | CLOB | (4000) | ||
| OBJECT_VERSION_NUMBER | NUMBER | (15) | Yes | |
| DISPLAY_COLUMN | VARCHAR2 | (1) | ||
| ZD_EDITION_NAME | VARCHAR2 | (30) | Yes |
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#;
CN
CN_OBJECTS_ALL
APPS
CN_OBJECTS
CN_OBJECTS_ALL
CN_OBJECTS_ALL+
|
|
|
|