Query to check concurrent program’s responsibilities
REQUIREMENT : Query to find all responsibilities to which a concurrent program is attached. /********************************************************** * PURPOSE: Find all responsibilities to which a concurrent* * program is attached * * AUTHOR: Anirudh Sethi * **********************************************************/ 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, […]