1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Query to Find Details of Request Set

Discussion in 'Oracle Apps Technical' started by malli_18arjun, Nov 13, 2011.

  1. malli_18arjun

    malli_18arjun Active Member

    Messages:
    36
    Likes Received:
    3
    Trophy Points:
    110
    Location:
    Hyderabad
    Introduction

    Query helps to find desired concurrent request set information .

    Pass concurrent request set name as parameter

    SQL Code:
    Code (SQL):
     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 = :request_set_name
        ORDER BY 1,2,3,4
     
    Thanks
    Malli