DBA Data[Home] [Help]

APPS.OKS_UPGRADE_PRECHECK dependencies on ALL_INDEXES

Line 972: From all_indexes

968: where read_only_flag = 'U';
969:
970: cursor get_cov_sch_index(c_owner in varchar2) is
971: Select index_name
972: From all_indexes
973: Where index_name like 'OKC_K_LINES_B_UPG'
974: and owner = c_owner;
975:
976: Cursor get_mtl_index(c_owner in varchar2) is

Line 978: From all_indexes

974: and owner = c_owner;
975:
976: Cursor get_mtl_index(c_owner in varchar2) is
977: Select index_name
978: From all_indexes
979: Where index_name like 'COV_SCH_ID_N10'
980: and owner = c_owner;
981:
982: l_owner varchar2(100);