DBA Data[Home] [Help]

APPS.BOM_DELETE_GROUPS_API dependencies on ALL_OBJECTS

Line 1449: ALL_OBJECTS AO

1445: schema_name VARCHAR2,
1446: oracle_user VARCHAR2) IS
1447: SELECT distinct ATC.COLUMN_NAME COLUMN_NAME
1448: FROM ALL_TAB_COLUMNS ATC,
1449: ALL_OBJECTS AO
1450: WHERE TABLE_NAME = trim(prod_table)
1451: AND ( ( AO.OBJECT_TYPE = 'TABLE' AND ATC.OWNER = schema_name )
1452: OR ( AO.OBJECT_TYPE = 'VIEW' AND ATC.OWNER = oracle_user ) )
1453: AND AO.OBJECT_NAME = trim(prod_table)