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 Concurrent Program Responsibility

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

    This query helps to get concurrent program details of to which responsibility attached and request group information. Thought it would be helpful ..

    Pass Concurrent Program 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_concurrent_program_name
        FROM fnd_Responsibility fr, fnd_responsibility_tl frt,
        fnd_request_groups frg, fnd_request_group_units frgu,
        fnd_concurrent_programs_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.concurrent_program_id = frgu.request_unit_id
        AND frt.LANGUAGE = USERENV('LANG')
        AND fcpt.LANGUAGE = USERENV('LANG')
        AND fcpt.user_concurrent_program_name = :conc_prg_name
        ORDER BY 1,2,3,4
     
    Thanks
    Malli
     
  2. raju

    raju Active Member

    Messages:
    2
    Likes Received:
    0
    Trophy Points:
    55
    Thanks,helpful for us