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 get User Names of the Responsibility

Discussion in 'Oracle Apps Technical' started by Raviprakash, Oct 25, 2014.

  1. Raviprakash

    Raviprakash Forum Genius

    Messages:
    14
    Likes Received:
    2
    Trophy Points:
    785
    Query to get User Names of the Responsibility Attached
    -------------------------------------------------------------------
    SELECT UNIQUE PAPF.FULL_NAME,
    FU.USER_NAME,
    FRT.RESPONSIBILITY_ID,
    FRT.RESPONSIBILITY_NAME,
    FRV.RESPONSIBILITY_KEY,
    FRV.APPLICATION_ID,
    FURG.END_DATE,
    FRV.END_DATE,
    FU.END_DATE
    FROMAPPS.FND_USER FU,
    APPS.FND_USER_RESP_GROUPS FURG,
    APPS.FND_RESPONSIBILITY_TL FRT,
    APPS.FND_RESPONSIBILITY_VL FRV,
    APPS.PER_ALL_PEOPLE_F PAPF
    WHERE FU.USER_ID = FURG.USER_ID
    ANDFURG.RESPONSIBILITY_ID = FRT.RESPONSIBILITY_ID
    ANDFRT.RESPONSIBILITY_ID = FRV.RESPONSIBILITY_ID
    ANDPAPF.PERSON_ID = FU.EMPLOYEE_ID
    ANDFRT.RESPONSIBILITY_NAME = 'Receivable Manager' -- Example
     
  2. yowancristo

    yowancristo Forum Advisor

    Messages:
    103
    Likes Received:
    10
    Trophy Points:
    305
    Location:
    Bangalore
    Nice info Ravi,

    But this query will give results for FND user only if associated with a Person in HRMS. Outer Joing of FND_USER with PER_ALL_PEOPLE_F will give complete list of users having the responsibility.:)

    Thanks,
    Yowan Cristo