Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to find currency code for org through SQL (EBS Version 12)
Need to find currency code for org through SQL [message #399358] Tue, 21 April 2009 15:47 Go to next message
urwethe
Messages: 11
Registered: November 2008
Location: New Jersey
Junior Member
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
Re: Need to find currency code for org through SQL [message #399396 is a reply to message #399358] Wed, 22 April 2009 01:12 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Not sure this table contains all the org_ids but, you can join financials_system_params_all.set_of_books_id -> gl_ledgers.ledger_id

By
Vamsi
Re: Need to find currency code for org through SQL [message #399466 is a reply to message #399396] Wed, 22 April 2009 06:36 Go to previous message
urwethe
Messages: 11
Registered: November 2008
Location: New Jersey
Junior Member
Thanks Vamsi!!
Previous Topic: GL and AR Balances Are Not Matching
Next Topic: how to view only approved purchase orders using form personalization
Goto Forum:
  


Current Time: Thu Dec 08 04:22:34 CST 2016

Total time taken to generate the page: 0.09804 seconds