APPS.BIS_MV_REFRESH dependencies on ALL_MVIEWS

Line 103: l_compile_state all_mviews.compile_state%type;

99: ) IS
100: l_stmt varchar2(2000);
101: l_errbuf varchar2(2000);
102: l_retcode number;
103: l_compile_state all_mviews.compile_state%type;
104:
105: CURSOR C_MV_CSTATE ( P_MVNAME bis_obj_dependency.object_name%TYPE, p_apps_schema_name varchar2 )
106: IS
107: select NVL(compile_state, 'NA')

Line 108: from all_mviews

104:
105: CURSOR C_MV_CSTATE ( P_MVNAME bis_obj_dependency.object_name%TYPE, p_apps_schema_name varchar2 )
106: IS
107: select NVL(compile_state, 'NA')
108: from all_mviews
109: where mview_name = p_mvname
110: AND owner = p_apps_schema_name
111: UNION ALL
112: SELECT NVL(compile_state, 'NA')

Line 113: FROM all_mviews mvs, user_synonyms s

109: where mview_name = p_mvname
110: AND owner = p_apps_schema_name
111: UNION ALL
112: SELECT NVL(compile_state, 'NA')
113: FROM all_mviews mvs, user_synonyms s
114: WHERE mvs.owner = s.table_owner
115: AND mvs.mview_name = s.table_name
116: AND mview_name = p_mvname;
117:

Line 502: SELECT count(*) INTO l_count FROM ALL_MVIEWS

498: BEGIN
499: IF (g_apps_schema_name IS NULL) THEN
500: g_apps_schema_name := get_apps_schema_name;
501: END IF;
502: SELECT count(*) INTO l_count FROM ALL_MVIEWS
503: WHERE OWNER = g_apps_schema_name AND MVIEW_NAME = p_mvname;
504: IF (l_count = 0) THEN
505: -- G_ERRBUF := 'Not a valid MV Name: ' || P_MVNAME;
506: -- G_ERRCODE := -1;

Line 528: FROM ALL_MVIEWS

524: END IF;
525:
526: SELECT FAST_REFRESHABLE, REFRESH_METHOD
527: INTO l_fast_refreshable, l_refresh_method
528: FROM ALL_MVIEWS
529: WHERE OWNER = g_apps_schema_name AND MVIEW_NAME = p_mvname;
530:
531: IF( l_refresh_method = 'COMPLETE' OR l_fast_refreshable = 'NO' ) THEN
532: BIS_COLLECTION_UTILITIES.put_line( p_mvname || ' is not Fast Refreshable!');

Line 929: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;

925: c_check_mv_valid curType;
926:
927:
928: l_row_count number;
929: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;
930: l_mv_owner ALL_MVIEWS.OWNER%type;
931: l_mv_last_refresh date;
932: l_mv_implementation_flag varchar2(1);
933:

Line 930: l_mv_owner ALL_MVIEWS.OWNER%type;

926:
927:
928: l_row_count number;
929: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;
930: l_mv_owner ALL_MVIEWS.OWNER%type;
931: l_mv_last_refresh date;
932: l_mv_implementation_flag varchar2(1);
933:
934: ---this cursor fetches all MV logs that have

Line 944: all_mviews b,

940: l.log_owner log_owner,
941: l.master master_name
942: from
943: bis_obj_properties a,
944: all_mviews b,
945: all_mview_refresh_times t,
946: all_mview_logs l
947: where a.object_type=''MV''
948: and nvl(a.implementation_flag,''N'')=''N''

Line 1185: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;

1181: ';
1182:
1183:
1184: l_row_count number;
1185: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;
1186: l_mv_owner ALL_MVIEWS.OWNER%type;
1187: l_mv_last_refresh date;
1188: l_mv_implementation_flag varchar2(1);
1189:

Line 1186: l_mv_owner ALL_MVIEWS.OWNER%type;

1182:
1183:
1184: l_row_count number;
1185: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;
1186: l_mv_owner ALL_MVIEWS.OWNER%type;
1187: l_mv_last_refresh date;
1188: l_mv_implementation_flag varchar2(1);
1189:
1190: ---this cursor fetches all MV logs that have

Line 1200: all_mviews b,

1196: l.log_owner log_owner,
1197: l.master master_name
1198: from
1199: bis_obj_properties a,
1200: all_mviews b,
1201: all_mview_refresh_times t,
1202: all_mview_logs l
1203: where a.object_type=''MV''
1204: and nvl(a.implementation_flag,''N'')=''N''