eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BOM_DELETE_GROUPS_API dependencies on ALL_OBJECTS

Line 1456: ALL_OBJECTS AO

1452: schema_name VARCHAR2,
1453: oracle_user VARCHAR2) IS
1454: SELECT distinct ATC.COLUMN_NAME COLUMN_NAME
1455: FROM ALL_TAB_COLUMNS ATC,
1456: ALL_OBJECTS AO
1457: WHERE TABLE_NAME = trim(prod_table)
1458: AND ( ( AO.OBJECT_TYPE = 'TABLE' AND ATC.OWNER = schema_name )
1459: OR ( AO.OBJECT_TYPE = 'VIEW' AND ATC.OWNER = oracle_user ) )
1460: AND AO.OBJECT_NAME = trim(prod_table)

Line 1478: ALL_OBJECTS AO

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,
1478: ALL_OBJECTS AO
1479: WHERE ( ( AO.OBJECT_TYPE = 'TABLE' AND ATC.OWNER = schema_name )
1480: OR ( AO.OBJECT_TYPE = 'VIEW' AND ATC.OWNER = oracle_user )
1481: )
1482: AND AO.OBJECT_NAME = ATC.table_name

Line 1490: ALL_OBJECTS AO

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
1494: AND AO.OWNER = ATC.OWNER