DBA Data[Home] [Help]

APPS.FND_APD dependencies on FND_CONCURRENT_REQUESTS

Line 70: from fnd_concurrent_requests fcr, fnd_application fa,

66: || '.trc' , instance_name, parent_request_id,
67: version
68: into module_id, flow_id, vduration, phase_code , status_code,
69: sdate, cdate, tracefile , vdbname, parentreqid, vversion
70: from fnd_concurrent_requests fcr, fnd_application fa,
71: fnd_concurrent_programs fcp, v$instance
72: where fcr.request_id = p_req_id
73: and fcr.program_application_id = fa.application_id
74: and fcr.concurrent_program_id = fcp.concurrent_program_id

Line 166: from fnd_concurrent_requests fcr, fnd_application fa,

162: lower(instance_name) || '_ora_' || fcr.oracle_process_id
163: || '_' || p_req_id || '.trc' , instance_name, parent_request_id,
164: version
165: into module_id, flow_id, tracefile , vdbname, parentreqid, vversion
166: from fnd_concurrent_requests fcr, fnd_application fa,
167: fnd_concurrent_programs fcp, v$instance
168: where fcr.request_id = p_req_id
169: and fcr.program_application_id = fa.application_id
170: and fcr.concurrent_program_id = fcp.concurrent_program_id

Line 254: from fnd_concurrent_requests fcr, fnd_application fa,

250: lower(instance_name) || '_ora_' || fcr.oracle_process_id
251: || '_' || p_req_id || '.trc' , instance_name, parent_request_id,
252: version
253: into module_id,flow_id,vduration,tracefile,vdbname,parentreqid,vversion
254: from fnd_concurrent_requests fcr, fnd_application fa,
255: fnd_concurrent_programs fcp, v$instance
256: where fcr.request_id = p_req_id
257: and fcr.program_application_id = fa.application_id
258: and fcr.concurrent_program_id = fcp.concurrent_program_id;