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!

Currency o f ou ?

Discussion in 'Oracle Apps Technical' started by sambhaji, Nov 19, 2013.

  1. sambhaji

    sambhaji Active Member

    Messages:
    62
    Likes Received:
    2
    Trophy Points:
    160
    Hi All,

    How to get currency of a operating unit in muti org.
    Please tell the table name.

    Regards
    Sambhaji
     
  2. sambuduk

    sambuduk Forum Advisor

    Messages:
    242
    Likes Received:
    73
    Trophy Points:
    455
    Location:
    Hyderabad , Telangana
    Hi ,

    Try with the below query.

    Code (SQL):

    SELECT hou.name Operating_unit , pb.currency_code
    FROM   hr_operating_units hou
          ,per_business_groups pb
    WHERE  hou.business_group_id = pb.business_group_id
    AND    hou.name = 'Vision Operations'

    Regards
    Sambasiva Reddy.K
     
    sambhaji likes this.