Thursday 26 May 2022

Currency code and Currency detail in oracle Fusion

select a.enterprise_id, a.currency_code, a.CURRENCY_CODE || '-' || b.NAME

  from FND_CURRENCIES_B a, FND_CURRENCIES_TL b

 where a.enterprise_id = b.enterprise_id

   and a.currency_code = b.currency_code

   and a.enabled_flag = 'Y'

   and a.currency_flag = 'Y'

   and a.iso_flag = 'Y'

   and b.language = 'US'

No comments:

Post a Comment

Query to get Business unit (ORGANIZATION_ID) Detail in oracle Fusion

  SELECT HAO.ORGANIZATION_ID AS BUSINESS_UNIT_ID,         HAOT.NAME,         HAO.BUSINESS_GROUP_ID,         HAO.EFFECTIVE_START_DATE,       ...