DBA Data[Home] [Help]

APPS.MSC_REFRESH_MV dependencies on DUAL

Line 38: select nvl(ltrim(rtrim(upper(p_mv_name))), '@@@') into l_mv_name from dual;

34: into l_apps_schema
35: from fnd_oracle_userid
36: where read_only_flag = 'U';
37:
38: select nvl(ltrim(rtrim(upper(p_mv_name))), '@@@') into l_mv_name from dual;
39: msc_util.msc_log('Snapshot is :'||l_mv_name);
40:
41: --Bug#12964070
42: IF l_mv_name = 'MSC_ATP_PLAN_SN' THEN