DBA Data[Home] [Help]

APPS.MSC_REFRESH_MV dependencies on FND_ORACLE_USERID

Line 19: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b

15: l_mv_name varchar2(240) ;
16:
17: Cursor application_schema IS
18: SELECT a.oracle_username
19: FROM FND_ORACLE_USERID a, FND_PRODUCT_INSTALLATIONS b
20: WHERE a.oracle_id = b.oracle_id
21: AND b.application_id= p_schema_id;
22:
23: Cursor mv_exist(p_mv_trim_name varchar2, p_schema_name varchar2) IS

Line 35: from fnd_oracle_userid

31: RETCODE:= G_SUCCESS;
32:
33: select oracle_username
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);