DBA Data[Home] [Help]

APPS.FND_CONC dependencies on FND_CONCURRENT_PROGRAMS

Line 149: fnd_concurrent_programs p

145: avg_days,
146: expctd_finish
147: from fnd_conc_stat_summary,
148: fnd_concurrent_requests r,
149: fnd_concurrent_programs p
150: where request_id = reqid
151: and program_application_id = application_id
152: and p.concurrent_program_id = r.concurrent_program_id
153: and concurrent_program_name = program_name

Line 378: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp

374: begin
375: /* changed query for BUG#5007915 SQLID#14602696 */
376: select request_id
377: into ra_reqid
378: from fnd_concurrent_requests fcr, fnd_concurrent_programs fcp
379: where fcp.run_alone_flag = 'Y'
380: and fcp.concurrent_program_id = fcr.concurrent_program_id
381: and fcp.application_id = fcr.program_application_id
382: and fcr.phase_code = 'R'

Line 800: from fnd_concurrent_requests R, fnd_concurrent_programs_vl CP,

796: P_ENABLED, P_CONTROLLING_MANAGER,
797: P_PROGRAM, P_QUEUE_CONTROL_FLAG,
798: P_QUEUE_METHOD_CODE, P_RUN_ALONE_FLAG,
799: P_SINGLE_THREAD_FLAG, P_REQLIMIT_FLAG, P_CD_ID, P_EDITION_NAME
800: from fnd_concurrent_requests R, fnd_concurrent_programs_vl CP,
801: fnd_user U1, fnd_user U2,
802: fnd_application_vl FA
803: where R.request_id = diagnose.request_id
804: and R.program_application_id = FA.application_id