APPS.BOM_DIAGUNITTEST_ITMHLCHK dependencies on ALL_INDEXES

Line 59: from all_indexes

55: order by attribute_name;
56:
57: Cursor list_of_unique_indexes(l_owner VARCHAR2) Is
58: select index_name
59: from all_indexes
60: where table_name = 'MTL_SYSTEM_ITEMS_B'
61: and owner = l_owner
62: and UNIQUENESS = 'UNIQUE';
63:

Line 206: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). For accessing all_indexes

202:
203: /* Script for Unique Index suggestion for Item Number segments in MSIB */
204:
205: /* Get the application installation info. References to Data Dictionary Objects without schema name
206: included in WHERE predicate are not allowed (GSCC Check: file.sql.47). For accessing all_indexes
207: in cursor list_of_unique_indexes and all_ind_columns in the query below we need to pass the schema name*/
208:
209: l_ret_status := fnd_installation.get_app_info ('INV'
210: , l_status