Friday 8 May 2020

Query to get functional currency of invoice in oracle apps

mo_global.set_policy_context('S',l_org_id);

SELECT currency_code
--INTO l_functional_currency_code
FROM gl_ledgers sob
, ar_system_parameters ar
WHERE sob.ledger_id = ar.set_of_books_id;

No comments:

Post a Comment