Thursday 4 April 2013

Query to findout the Responsibilites name from Request Set

SELECT frt.responsibility_name,
  frg.request_group_name,
  frgu.request_unit_type,
  frgu.request_unit_id,
  fcpt.user_request_set_name
FROM apps.fnd_Responsibility fr,
  apps.fnd_responsibility_tl frt,
  apps.fnd_request_groups frg,
  apps.fnd_request_group_units frgu,
  apps.fnd_request_Sets_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.request_set_id     = frgu.request_unit_id
  --and frt.language = USERENV('LANG')
  --and fcpt.language = USERENV('LANG')
AND fcpt.user_request_set_name LIKE '%GEPS GL US Payroll Interface Request Set%'
ORDER BY 1,2,3,4;

No comments:

Post a Comment