DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on DBA_TAB_COLUMNS

Line 1473: dba_tab_columns col

1469: (SELECT col.column_name,
1470: col.owner,
1471: syn.synonym_name AS table_name
1472: FROM user_synonyms syn,
1473: dba_tab_columns col
1474: WHERE col.owner = syn.table_owner
1475: AND col.table_name = syn.table_name
1476: AND syn.synonym_name = trim(prod_table)
1477: ) ATC,

Line 1489: FROM DBA_TAB_COLUMNS ATC,

1485: -- user_synonyms when run from APPS schema. eg. BIC. So doing a UNION ALL
1486: -- with following SQL
1487: UNION ALL
1488: SELECT DISTINCT ATC.COLUMN_NAME COLUMN_NAME
1489: FROM DBA_TAB_COLUMNS ATC,
1490: ALL_OBJECTS AO
1491: WHERE AO.OBJECT_TYPE = 'VIEW'
1492: AND ATC.OWNER = oracle_user
1493: AND AO.OBJECT_NAME = ATC.table_name