DBA Data[Home] [Help]

APPS.BSC_MV_ADAPTER dependencies on ALL_OBJECTS

Line 567: select count(1) from all_objects where

563: l_zero_code_mv BSC_IM_UTILS.varchar_tabletype;
564: l_number_zero_code_mv number;
565: l_owner varchar2(100);
566: cursor cZMV(p_owner varchar2, p_zmv_name varchar2) is
567: select count(1) from all_objects where
568: owner=p_owner and object_name=p_zmv_name
569: and object_type = 'MATERIALIZED VIEW';
570: begin
571: l_zmv := upper(substr(p_mv_name, 1, instr(p_mv_name, '_MV', -1)))||'ZMV';