Order Management - EBS (MOSC)

MOSC Banner

Currency code for Sales order creation

edited Apr 10, 2020 5:06AM in Order Management - EBS (MOSC) 2 commentsAnswered

Hi experts,

I want to get the query to retrieve the currency codes to be shown when creating an order.

I debugged OEXOEORD.fmb form, which is the form to create a sales order, and got the following query which retrieves 53 rows.

select a.currency_code,b.name,b.description from fnd_currencies a, fnd_currencies_tl b

        where enabled_flag = 'Y'

        and currency_flag = 'Y'

        and a.currency_code = b.currency_code

        and trunc(nvl(start_date_active,sysdate))<=trunc(sysdate) and trunc(nvl(end_date_active,sysdate))>=trunc(sysdate) ;

But i found that the currency code list shows only a few of the currencies in the list and it changes with the price list which i choose.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center