OraFAQ Forum: Oracle Fusion Apps & E-Business Suite » Need to find currency code for org through SQL

Home » Applications » Oracle Fusion Apps & E-Business Suite » Need to find currency code for org through SQL (EBS Version 12)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Need to find currency code for org through SQL [message #399358]

Tue, 21 April 2009 15:47

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

Report message to a moderator

Re: Need to find currency code for org through SQL [message #399396 is a reply to message #399358]

Wed, 22 April 2009 01:12

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: Need to find currency code for org through SQL [message #399466 is a reply to message #399396]

Wed, 22 April 2009 06:36

urwethe
Messages: 11
Registered: November 2008
Location: New Jersey

Junior Member

Thanks Vamsi!!

Report message to a moderator

Previous Topic:	GL and AR Balances Are Not Matching
Next Topic:	how to view only approved purchase orders using form personalization

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 19:50:44 CST 2024