APPS.BIS_MV_REFRESH dependencies on ALL_SNAPSHOT_LOGS

Line 1036: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;

1032: l_mview_name varchar2(30);
1033:
1034:
1035: l_impl_flag varchar2(1);
1036: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;
1037: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;
1038: l_mview_id number;
1039: l_prefix varchar2(30):=' ';
1040: l_prog_req_id number;

Line 1037: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;

1033:
1034:
1035: l_impl_flag varchar2(1);
1036: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;
1037: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;
1038: l_mview_id number;
1039: l_prefix varchar2(30):=' ';
1040: l_prog_req_id number;
1041:

Line 1220: all_snapshot_logs b

1216: ---this cursor fetches mview_ids from all_base_table_mviews
1217: l_mv_id varchar2(2000):='
1218: select distinct a.mview_id
1219: from all_base_table_mviews a,
1220: all_snapshot_logs b
1221: where a.owner=:1
1222: and a.master=b.master
1223: and a.owner=b.LOG_OWNER
1224: and b.log_table=:2'

Line 1233: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;

1229: l_mview_name varchar2(30);
1230:
1231:
1232: l_impl_flag varchar2(1);
1233: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;
1234: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;
1235: l_mview_id number;
1236: l_prefix varchar2(30):=' ';
1237: l_check_dissociated varchar2(30);

Line 1234: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;

1230:
1231:
1232: l_impl_flag varchar2(1);
1233: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;
1234: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;
1235: l_mview_id number;
1236: l_prefix varchar2(30):=' ';
1237: l_check_dissociated varchar2(30);
1238: BEGIN