VIEW: APPS.CN_OBJ_TABLES_V

Source

View Text - Preformatted

SELECT o.rowid ,o.object_id ,o.org_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.alias ,o.table_level ,o.table_type ,o.seed_object_id ,o.object_type ,o.schema , o.calc_eligible_flag ,o.user_name FROM CN_OBJECTS O WHERE o.object_type = 'TBL'

View Text - HTML Formatted

SELECT O.ROWID
, O.OBJECT_ID
, O.ORG_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.ALIAS
, O.TABLE_LEVEL
, O.TABLE_TYPE
, O.SEED_OBJECT_ID
, O.OBJECT_TYPE
, O.SCHEMA
, O.CALC_ELIGIBLE_FLAG
, O.USER_NAME
FROM CN_OBJECTS O
WHERE O.OBJECT_TYPE = 'TBL'