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 925: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;

921: c_check_mv_valid curType;
922:
923:
924: l_row_count number;
925: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;
926: l_mv_owner ALL_MVIEWS.OWNER%type;
927: l_mv_last_refresh date;
928: l_mv_implementation_flag varchar2(1);
929:

Line 926: l_mv_owner ALL_MVIEWS.OWNER%type;

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

Line 940: all_mviews b,

936: l.log_owner log_owner,
937: l.master master_name
938: from
939: bis_obj_properties a,
940: all_mviews b,
941: all_mview_refresh_times t,
942: all_mview_logs l
943: where a.object_type=''MV''
944: and nvl(a.implementation_flag,''N'')=''N''

Line 1181: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;

1177: ';
1178:
1179:
1180: l_row_count number;
1181: l_mv_name ALL_MVIEWS.MVIEW_NAME%type;
1182: l_mv_owner ALL_MVIEWS.OWNER%type;
1183: l_mv_last_refresh date;
1184: l_mv_implementation_flag varchar2(1);
1185:

Line 1182: l_mv_owner ALL_MVIEWS.OWNER%type;

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

Line 1196: all_mviews b,

1192: l.log_owner log_owner,
1193: l.master master_name
1194: from
1195: bis_obj_properties a,
1196: all_mviews b,
1197: all_mview_refresh_times t,
1198: all_mview_logs l
1199: where a.object_type=''MV''
1200: and nvl(a.implementation_flag,''N'')=''N''