Finding concurrent program assigned to which responsibilities
Finding concurrent program assigned to which responsibilities SELECT cp . user_concurrent_program_name , rg . request_group_name , rv . responsibility_name FROM fnd_concurrent_programs_vl cp , fnd_request_group_units rgu , fnd_request_groups rg , fnd_responsibility_vl rv WHERE rgu . request_unit_id = cp . concurrent_program_id AND rg . request_group_id = rgu . request_group_id AND rg . request_group_id = rv . request_group_id --AND CP.CONCURRENT_PROGRAM_id=42419 AND cp . user_concurrent_program_name LIKE 'XXCUST%NA%COGS%'