1. Tables and Views for Financials
  2. EXM_CARD_CURRENCIES_V

EXM_CARD_CURRENCIES_V

Details

  • Schema: FUSION

  • Object owner: EXM

  • Object type: VIEW

Columns

Name

CURRENCY_CODE

NUMERIC_CURRENCY_CODE

Query

SQL_Statement

SELECT

CURRENCY_CODE, NUMERIC_CURRENCY_CODE FROM (

SELECT CURRENCY_CODE,NUMERIC_CURRENCY_CODE FROM EXM_CARD_CURRENCIES

UNION

SELECT FNDCVL.CURRENCY_CODE, FNDCVL.DIGITAL_CURRENCY_CODE FROM FND_CURRENCIES_VL FNDCVL WHERE DIGITAL_CURRENCY_CODE IS NOT NULL

AND FNDCVL.ENABLED_FLAG = 'Y'

AND FNDCVL.CURRENCY_FLAG = 'Y'

AND TRUNC(NVL(FNDCVL.START_DATE_ACTIVE, SYSDATE)) <= TRUNC(SYSDATE)

AND TRUNC(NVL(FNDCVL.END_DATE_ACTIVE, SYSDATE)) >= TRUNC(SYSDATE)

)