Tuesday, July 19, 2016

To get the request details by Request id

SELECT
user_concurrent_program_name,
responsibility_name,
request_date,
argument_text,
request_id,
phase_code,
status_code
FROM
fnd_concurrent_requests fcr,
fnd_concurrent_programs_tl fcp,
fnd_responsibility_tl fr,
fnd_user fu 
WHERE
fcr.concurrent_program_id = fcp.concurrent_program_id 
and fcr.responsibility_id = fr.responsibility_id 
and fcr.requested_by = fu.user_id
and request_id='27775711'
ORDER BY REQUEST_DATE DESC;

No comments:

Post a Comment

Oracle Fusion - Cost Lines and Expenditure Item link in Projects

SELECT   ccd.transaction_id,ex.expenditure_item_id,cacat.serial_number FROM fusion.CST_INV_TRANSACTIONS cit,   fusion.cst_cost_distribution_...