APPS.BSC_PMD_OPT_DOC_UTIL dependencies on BSC_KPI_DATA_TABLES

Line 443: SELECT distinct TABLE_NAME,MV_NAME,decode(substr(MV_NAME,-3),'ZMV','ZMV','MV') mv_type FROM BSC_KPI_DATA_TABLES where MV_NAME is not null;

439: -- aguwalan : bug fix#4602415 : Added code to build PL/SQL table rather than expensive query
440: PROCEDURE BUILD_STABLE_MV_ZMV_REP
441: IS
442: CURSOR build_table_mv IS
443: SELECT distinct TABLE_NAME,MV_NAME,decode(substr(MV_NAME,-3),'ZMV','ZMV','MV') mv_type FROM BSC_KPI_DATA_TABLES where MV_NAME is not null;
444: BEGIN
445: OPEN build_table_mv;
446: LOOP
447: FETCH build_table_mv BULK COLLECT INTO l_tab_mv;