APPS.FND_OAM_COLLECTION dependencies on FND_CONC_PROG_ONSITE_INFO

Line 2387: fnd_conc_prog_onsite_info fcpoi,

2383: select fcr.request_id request_id,
2384: fcp.user_concurrent_program_name user_concurrent_program_name
2385: from
2386: fnd_concurrent_requests fcr,
2387: fnd_conc_prog_onsite_info fcpoi,
2388: fnd_concurrent_programs_vl fcp
2389: where
2390: fcr.program_application_id=fcpoi.program_application_id
2391: AND fcp.application_id = fcr.PROGRAM_APPLICATION_ID

Line 2483: fnd_conc_prog_onsite_info fcpoi,

2479: fcpoi.alert_long_running_threshold/60 threshold_minutes,
2480: fcpoi.alert_long_running_tolerance tolerance
2481: from
2482: fnd_concurrent_requests fcr,
2483: fnd_conc_prog_onsite_info fcpoi,
2484: fnd_concurrent_programs_vl fcp
2485: where
2486: fcr.program_application_id=fcpoi.program_application_id
2487: AND fcp.CONCURRENT_PROGRAM_ID=fcr.CONCURRENT_PROGRAM_ID

Line 2528: from fnd_conc_prog_onsite_info

2524:
2525: if(v_spec_long_run_enabled ='Y') then
2526: --debug('v_spec_long_run_enabled is Y');
2527: select count(*) into v_spec_cnt
2528: from fnd_conc_prog_onsite_info
2529: where ALERT_LONG_RUNNING_ENABLED='Y' and rownum < 2;
2530: if (v_spec_cnt > 0) then
2531: open spec_req_id_list;
2532: fetch spec_req_id_list bulk collect

Line 2586: fnd_conc_prog_onsite_info fcpoi,

2582: select fcr.request_id request_id,
2583: fcp.user_concurrent_program_name user_concurrent_program_name
2584: from
2585: fnd_concurrent_requests fcr,
2586: fnd_conc_prog_onsite_info fcpoi,
2587: fnd_concurrent_programs_vl fcp
2588: where
2589: fcr.program_application_id=fcpoi.program_application_id
2590: AND fcp.application_id = fcr.PROGRAM_APPLICATION_ID

Line 2673: fnd_conc_prog_onsite_info fcpoi,

2669: fcp.user_concurrent_program_name user_concurrent_program_name,
2670: nvl(fcpoi.ALERT_LONG_PENDING_TOLERANCE,0)/60 tolerance_minutes
2671: from
2672: fnd_concurrent_requests fcr,
2673: fnd_conc_prog_onsite_info fcpoi,
2674: fnd_concurrent_programs_vl fcp
2675: where
2676: fcr.program_application_id=fcpoi.program_application_id
2677: AND fcp.application_id = fcr.PROGRAM_APPLICATION_ID

Line 2709: from fnd_conc_prog_onsite_info

2705: where metric_short_name ='SPECIFIC_LONG_PENDING_ENABLED';
2706:
2707: if (v_spec_long_pend_enabled ='Y') then
2708: select count(*) into v_spec_cnt
2709: from fnd_conc_prog_onsite_info
2710: where ALERT_LONG_PENDING_ENABLED='Y' and rownum < 2;
2711:
2712: if (v_spec_cnt > 0) then
2713: open spec_req_id_list;