VIEW: APPS.CN_BASE_TABLES_V

Source

View Text - Preformatted

SELECT tab.name, tab.table_id,tab.org_id FROM cn_obj_tables_v tab, cn_obj_columns_v pk WHERE pk.primary_key = 'Y' AND pk.data_type = 'NUMBER' AND pk.dimension_id IS NULL AND pk.table_id = tab.table_id AND pk.org_id = tab.org_id UNION SELECT name, table_id,org_id FROM cn_obj_tables_v WHERE NOT EXISTS (SELECT 1 FROM cn_obj_columns_v WHERE primary_key = 'Y' AND table_id = cn_obj_tables_v.table_id AND org_id = cn_obj_tables_v.org_id ) AND table_id IN (SELECT table_id FROM cn_obj_columns_v WHERE data_Type = 'NUMBER')

View Text - HTML Formatted

SELECT TAB.NAME
, TAB.TABLE_ID
, TAB.ORG_ID
FROM CN_OBJ_TABLES_V TAB
, CN_OBJ_COLUMNS_V PK
WHERE PK.PRIMARY_KEY = 'Y'
AND PK.DATA_TYPE = 'NUMBER'
AND PK.DIMENSION_ID IS NULL
AND PK.TABLE_ID = TAB.TABLE_ID
AND PK.ORG_ID = TAB.ORG_ID UNION SELECT NAME
, TABLE_ID
, ORG_ID
FROM CN_OBJ_TABLES_V
WHERE NOT EXISTS (SELECT 1
FROM CN_OBJ_COLUMNS_V
WHERE PRIMARY_KEY = 'Y'
AND TABLE_ID = CN_OBJ_TABLES_V.TABLE_ID
AND ORG_ID = CN_OBJ_TABLES_V.ORG_ID )
AND TABLE_ID IN (SELECT TABLE_ID
FROM CN_OBJ_COLUMNS_V
WHERE DATA_TYPE = 'NUMBER')