VIEW: APPS.CN_OBJ_COLUMNS_V

Source

View Text - Preformatted

SELECT o.rowid, o.object_id, o.last_update_date, o.last_updated_by, o.creation_date, o.created_by, o.last_update_login, o.name, o.description, o.dependency_map_complete, o.next_synchronization_date, o.synchronization_frequency, o.object_status, o.repository_id, o.table_id, o.data_length, o.data_type, o.nullable, o.primary_key, o.position, o.dimension_id, o.data_scale, o.column_type, o.user_column_name, o.seed_object_id, o.object_type, o.user_name, o.foreign_key, o.classification_column, o.calc_formula_flag, o. column_datatype, o.value_set_id, o.custom_call ,o.org_id FROM CN_OBJECTS O WHERE o.object_type = 'COL'

View Text - HTML Formatted

SELECT O.ROWID
, O.OBJECT_ID
, O.LAST_UPDATE_DATE
, O.LAST_UPDATED_BY
, O.CREATION_DATE
, O.CREATED_BY
, O.LAST_UPDATE_LOGIN
, O.NAME
, O.DESCRIPTION
, O.DEPENDENCY_MAP_COMPLETE
, O.NEXT_SYNCHRONIZATION_DATE
, O.SYNCHRONIZATION_FREQUENCY
, O.OBJECT_STATUS
, O.REPOSITORY_ID
, O.TABLE_ID
, O.DATA_LENGTH
, O.DATA_TYPE
, O.NULLABLE
, O.PRIMARY_KEY
, O.POSITION
, O.DIMENSION_ID
, O.DATA_SCALE
, O.COLUMN_TYPE
, O.USER_COLUMN_NAME
, O.SEED_OBJECT_ID
, O.OBJECT_TYPE
, O.USER_NAME
, O.FOREIGN_KEY
, O.CLASSIFICATION_COLUMN
, O.CALC_FORMULA_FLAG
, O. COLUMN_DATATYPE
, O.VALUE_SET_ID
, O.CUSTOM_CALL
, O.ORG_ID
FROM CN_OBJECTS O
WHERE O.OBJECT_TYPE = 'COL'