Monday, September 25, 2017

Query To Find Request Set Details

SELECT
  fav.application_short_name,
  fav.application_name,
  frt.responsibility_name,
  frg.request_group_name,
  fcpt.request_set_name,
  fcpt.user_request_set_name
FROM
  apps.fnd_responsibility_vl frt,
  apps.fnd_request_groups frg,
  apps.fnd_request_group_units frgu,
  apps.fnd_request_Sets_vl fcpt,
  apps.fnd_application_vl fav
WHERE 1 = 1
  AND frg.request_group_id = frt.request_group_id
  AND frgu.request_group_id = frg.request_group_id
  AND fcpt.request_set_id = frgu.request_unit_id
  AND fcpt.application_id = fav.application_id
  AND fcpt.user_request_set_name LIKE 'XXRJ%'

ORDER BY 1,2,3,4

2 comments:

Anonymous said...

Great beat ! I wish to apprentice while you amend your web site,
how can i subscribe for a blog website? The account aided me a acceptable deal.
I had been a little bit acquainted of this your broadcast provided bright clear
concept

Raju Chinthapatla said...

Please Like and Share our FaceBook page to get more details on Oracle Application

https://www.facebook.com/pages/Oracle-Applications/712588392100243

Thanks,
Raju

Post a Comment

Best Blogger TipsGet Flower Effect