View: IBE_BI_CURRENCY_V

Product:	IBE - iStore
Description:	This view returns the list of currencies supported by each Mini Site
Implementation/DBA Data:	APPS.IBE_BI_CURRENCY_V

View Text

SELECT IBMA.MSITE_ID
, IBMA.ORG_ID
, GSOB.CURRENCY_CODE
FROM IBE_BI_MSITEORG_MV IBMA
, FINANCIALS_SYSTEM_PARAMS_ALL FSP
, GL_SETS_OF_BOOKS GSOB
WHERE FSP.SET_OF_BOOKS_ID = GSOB.SET_OF_BOOKS_ID
AND FSP.ORG_ID = IBMA.ORG_ID GROUP BY IBMA.MSITE_ID
, IBMA.ORG_ID
, GSOB.CURRENCY_CODE

Columns