APPS.BOM_DELETE_GROUPS_API dependencies on USER_SYNONYMS

Line 1472: FROM user_synonyms syn,

1468: FROM
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)

Line 1485: -- user_synonyms when run from APPS schema. eg. BIC. So doing a UNION ALL

1481: )
1482: AND AO.OBJECT_NAME = ATC.table_name
1483: AND AO.OWNER = ATC.OWNER
1484: -- for cases wherein the object is a view then it wont be prsent in
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,

Line 1496: AND NOT EXISTS (SELECT 1 FROM user_synonyms WHERE synonym_name = trim(prod_table))

1492: AND ATC.OWNER = oracle_user
1493: AND AO.OBJECT_NAME = ATC.table_name
1494: AND AO.OWNER = ATC.OWNER
1495: AND AO.object_name = trim(prod_table)
1496: AND NOT EXISTS (SELECT 1 FROM user_synonyms WHERE synonym_name = trim(prod_table))
1497: ORDER BY 1;
1498:
1499: insert_stmt LONG;
1500: update_stmt LONG;