DBA Data[Home] [Help]

APPS.BSC_MO_HELPER_PKG dependencies on ALL_SNAPSHOT_LOGS

Line 6153: , all_snapshot_logs log

6149: PROCEDURE drop_unused_mvlogs IS
6150: CURSOR cDropThese IS
6151: select distinct level_table_name
6152: from bsc_sys_dim_levels_b lvl
6153: , all_snapshot_logs log
6154: where log.log_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
6155: and log.master = lvl.level_Table_name
6156: minus
6157: select distinct level_table_name

Line 6159: , all_snapshot_logs log

6155: and log.master = lvl.level_Table_name
6156: minus
6157: select distinct level_table_name
6158: from bsc_sys_dim_levels_b lvl
6159: , all_snapshot_logs log
6160: , all_dependencies db
6161: , all_mviews mv
6162: where log.log_owner=BSC_METADATA_OPTIMIZER_PKG.gBSCSchema
6163: and log.master = lvl.level_Table_name