APPS.BIS_BIA_REFRESH_REPORT dependencies on FND_CONCURRENT_REQUESTS

Line 65: fnd_concurrent_requests c,

61: pos,
62: v.meaning
63: FROM bis_request_set_objects_v o,
64: fnd_request_sets_vl s,
65: fnd_concurrent_requests c,
66: fnd_concurrent_programs p,
67: fnd_user u,
68: bis_request_set_options r,
69: fnd_common_lookups v

Line 104: l_request_id fnd_concurrent_requests.request_id%TYPE;

100: RETURN VARCHAR2
101: IS
102: sql_str VARCHAR2 (2000);
103: vorderby VARCHAR2 (200);
104: l_request_id fnd_concurrent_requests.request_id%TYPE;
105: l_request_set_id fnd_request_sets_vl.request_set_id%TYPE;
106: l_request_set_name fnd_request_sets_vl.request_set_name%TYPE;
107: l_user_request_set_name fnd_request_sets_vl.user_request_set_name%TYPE;
108: BEGIN

Line 167: FROM fnd_concurrent_requests con, fnd_request_set_stages_vl stg

163: bis_bia_refresh_report.time_interval(con.actual_completion_date
164: - con.requested_start_date
165: ) BIS_REQUEST_REFRESH_TIME
166:
167: FROM fnd_concurrent_requests con, fnd_request_set_stages_vl stg
168: WHERE con.priority_request_id = '
169: || l_request_id
170: || ' AND con.priority_request_id = con.parent_request_id
171: AND stg.request_set_id = '

Line 262: FROM fnd_concurrent_requests rset

258: , bis_bia_refresh_report.time_interval(rset.actual_completion_date
259: - rset.actual_start_date
260: ) BIS_REQUEST_REFRESH_TIME
261: , cprog.user_concurrent_program_name
262: FROM fnd_concurrent_requests rset
263: , fnd_concurrent_requests rset_stg
264: , fnd_concurrent_programs_vl cprog
265: , fnd_request_set_stages_vl stage
266: , bis_refresh_log brlog

Line 263: , fnd_concurrent_requests rset_stg

259: - rset.actual_start_date
260: ) BIS_REQUEST_REFRESH_TIME
261: , cprog.user_concurrent_program_name
262: FROM fnd_concurrent_requests rset
263: , fnd_concurrent_requests rset_stg
264: , fnd_concurrent_programs_vl cprog
265: , fnd_request_set_stages_vl stage
266: , bis_refresh_log brlog
267: WHERE rset.priority_request_id = &REQUEST_ID+REQUEST_ID

Line 317: FROM fnd_concurrent_requests rset

313: , bis_bia_refresh_report.time_interval(rset.actual_completion_date
314: - rset.actual_start_date
315: ) BIS_REQUEST_REFRESH_TIME
316: , cprog.user_concurrent_program_name
317: FROM fnd_concurrent_requests rset
318: , fnd_concurrent_requests rset_stg
319: , fnd_concurrent_programs_vl cprog
320: , fnd_request_set_stages_vl stage
321: , bis_refresh_log brlog

Line 318: , fnd_concurrent_requests rset_stg

314: - rset.actual_start_date
315: ) BIS_REQUEST_REFRESH_TIME
316: , cprog.user_concurrent_program_name
317: FROM fnd_concurrent_requests rset
318: , fnd_concurrent_requests rset_stg
319: , fnd_concurrent_programs_vl cprog
320: , fnd_request_set_stages_vl stage
321: , bis_refresh_log brlog
322: WHERE rset.priority_request_id = &REQUEST_ID+REQUEST_ID