DBA Data[Home] [Help]

APPS.WF_DIAGNOSTICS dependencies on USER_JOBS

Line 2290: user_jobs b

2286: b.what,
2287: b.last_Date,
2288: b.last_sec
2289: from fnd_svc_comp_requests a,
2290: user_jobs b
2291: WHERE a.component_id = p_comp_id
2292: AND a.job_id = b.job;
2293:
2294: begin

Line 3374: from user_jobs

3370: -- Removed check for concurrent request in order to make this work in Standalone too
3371: -- Originally the control queue cleanup is set up as DBMS job by wfctqcln.sql.
3372: -- Check if the dbms_job is running
3373: select count(1) into job_count
3374: from user_jobs
3375: where upper(what) like '%WF_BES_CLEANUP.CLEANUP_SUBSCRIBERS%'
3376: and broken = 'N';
3377:
3378: if (job_count = 0) then