---------Query to find Conccurrent Program Responsibility name—
SELECT fav.APPLICATION_NAME,frq.REQUEST_GROUP_NAME,request_unit_id,frq.*
FROM fnd_request_group_units frqu, fnd_request_groups frq, fnd_application_vl fav, fnd_concurrent_programs
WHERE 1=1--request_unit_id = 183400 ---conc prog id/request setid
and frqu.request_group_id=frq.request_group_id
and request_unit_id =CONCURRENT_PROGRAM_ID
and CONCURRENT_PROGRAM_NAME ='STATMENT_EMAIL'
and frq.application_id = fav.APPLICATION_ID
No comments:
Post a Comment