DBA Data[Home] [Help]

APPS.FND_WEBFILE dependencies on FND_CONCURRENT_PROGRAMS

Line 305: fnd_concurrent_programs fcp, fnd_application a

301: fcr.save_output_flag, fcr.ofile_size, fmt.file_format_code,
302: fcp.concurrent_program_name, a.application_short_name
303: into fname, node, mtype, save_out, fsize, ffcode, prog_name,appl_name
304: from fnd_concurrent_requests fcr, fnd_mime_types_vl fmt,
305: fnd_concurrent_programs fcp, fnd_application a
306: where fcr.request_id = id
307: and upper(fcr.output_file_type) = upper(fmt.file_format_code)
308: and fcp.concurrent_program_id = fcr.concurrent_program_id
309: and fcp.application_id = fcr.program_application_id

Line 350: from fnd_concurrent_programs fcp, fnd_application a, fnd_concurrent_requests fcr

346: begin
347: /* Find the parent program for the REPRINT request */
348: select fcp.concurrent_program_name, a.application_short_name
349: into prog_name, appl_name
350: from fnd_concurrent_programs fcp, fnd_application a, fnd_concurrent_requests fcr
351: where fcp.concurrent_program_id = fcr.concurrent_program_id
352: and fcp.application_id = fcr.program_application_id
353: and fcp.application_id = a.application_id
354: and fcr.request_id = (select to_number(argument1) from fnd_concurrent_requests where request_id=id);