APPS.BOM_DELETE_GROUPS_API dependencies on ALL_TAB_COLUMNS

Line 1448: FROM ALL_TAB_COLUMNS ATC,

1444: CURSOR col_list_cursor( prod_table VARCHAR2,
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 ) )

Line 1511: FROM ALL_TAB_COLUMNS COL1

1507: INTO dummy
1508: FROM DUAL
1509: WHERE EXISTS (
1510: SELECT NULL
1511: FROM ALL_TAB_COLUMNS COL1
1512: WHERE TABLE_NAME = trim(prod_table)
1513: AND NOT EXISTS (
1514: SELECT NULL
1515: FROM ALL_TAB_COLUMNS COL2

Line 1515: FROM ALL_TAB_COLUMNS COL2

1511: FROM ALL_TAB_COLUMNS COL1
1512: WHERE TABLE_NAME = trim(prod_table)
1513: AND NOT EXISTS (
1514: SELECT NULL
1515: FROM ALL_TAB_COLUMNS COL2
1516: WHERE TABLE_NAME = trim(archive_table)
1517: AND COL2.COLUMN_NAME = COL1.COLUMN_NAME));
1518: exception
1519: when no_data_found then