Oracle Apps

Query to find concurrent requests’ status for a given request id.

select fcr.request_id
,decode(fcr.phase_code,’P',decode(fcr.hold_flag,’Y',’Inactive’,fl_p.meaning),fl_p.meaning) phase
,decode(fcr.phase_code,’P',decode(fcr.hold_flag,’Y',’On Hold’,decode(sign(fcr.requested_start_date - sysdate),1,’Scheduled’,fl_s.meaning)),fl_s.meaning) status
from fnd_concurrent_requests fcr
,fnd_lookups fl_p
,fnd_lookups fl_s
where 1=1
and fcr.phase_code = fl_p.lookup_code
and fl_p.lookup_type = ‘CP_PHASE_CODE’
and fcr.status_code = fl_s.lookup_code
and fl_s.lookup_type = ‘CP_STATUS_CODE’
and fcr.request_id = &request_id
order by fcr.request_id desc;

Query to Get the Responsibility Name to which a concurrent program is attached:

SELECT frt.responsibility_name,
frg.request_group_name,
frgu.request_unit_type,
frgu.request_unit_id,
fcpt.user_concurrent_program_name
FROM fnd_responsibility fr,
fnd_responsibility_tl frt,
fnd_request_groups frg,
fnd_request_group_units frgu,
fnd_concurrent_programs_tl fcpt
WHERE frt.responsibility_id = fr.responsibility_id
AND frg.request_group_id = fr.request_group_id
AND frgu.request_group_id = frg.request_group_id
AND fcpt.concurrent_program_id = frgu.request_unit_id
AND frt.LANGUAGE = userenv('LANG')
AND fcpt.LANGUAGE = userenv('LANG')
AND fcpt.user_concurrent_program_name = 'BBY Payc Update Costs'
ORDER BY 1,2,3,4;