Currency code for Sales order creation
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.