APPS.BIS_MV_REFRESH dependencies on ALL_SNAPSHOT_LOGS

Line 1032: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;

1028: l_mview_name varchar2(30);
1029:
1030:
1031: l_impl_flag varchar2(1);
1032: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;
1033: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;
1034: l_mview_id number;
1035: l_prefix varchar2(30):=' ';
1036: l_prog_req_id number;

Line 1033: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;

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

Line 1216: all_snapshot_logs b

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

Line 1229: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;

1225: l_mview_name varchar2(30);
1226:
1227:
1228: l_impl_flag varchar2(1);
1229: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;
1230: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;
1231: l_mview_id number;
1232: l_prefix varchar2(30):=' ';
1233: l_check_dissociated varchar2(30);

Line 1230: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;

1226:
1227:
1228: l_impl_flag varchar2(1);
1229: l_log_table ALL_SNAPSHOT_LOGS.LOG_TABLE%type;
1230: l_log_owner ALL_SNAPSHOT_LOGS.LOG_OWNER%TYPE;
1231: l_mview_id number;
1232: l_prefix varchar2(30):=' ';
1233: l_check_dissociated varchar2(30);
1234: BEGIN