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!

Need to find Currency code for Org

Discussion in 'Oracle Financials' started by urwethe, Apr 21, 2009.

  1. urwethe

    urwethe Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    Hi,
    What sql query can I use to find the currency code for a given org? I have queried the GL_SETS_OF_BOOKS table but don't know the joins to acheive this.
    Thanks in advance.
    Bob
     
  2. sai194

    sai194 Active Member

    Messages:
    3
    Likes Received:
    0
    Trophy Points:
    55
    With that org_id query in ap_system_parameters_all , u will get base currency code.
     
  3. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    if it's only the inventory orgs whose currency code you need you can get directly from the view CST_ORGANIZATION_DEFINITIONS
     
  4. urwethe

    urwethe Active Member

    Messages:
    8
    Likes Received:
    0
    Trophy Points:
    55
    Thanks you folks!! :)
     
  5. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    you are welcome bro...
     
  6. anna575

    anna575 Active Member

    Messages:
    22
    Likes Received:
    1
    Trophy Points:
    90
    Hey, I also need to currency code for org. It is beneficial for us. Currency codes helps us in many ways. It's services are really great. Keep up a good work...