View: CLN_PROCAT_CURRENCIES_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of the available currencies the price list can be converted into
Implementation/DBA Data:	APPS.CLN_PROCAT_CURRENCIES_V

View Text

SELECT LH.CURRENCY_CODE CURRENCY_CODE
, 0 CURRENCY_DETAIL_ID
, LH.LIST_HEADER_ID LIST_HEADER_ID
FROM QP_LIST_HEADERS_B LH UNION (SELECT QCD.TO_CURRENCY_CODE CURRENCY_CODE
, QCD.CURRENCY_DETAIL_ID
, LH.LIST_HEADER_ID LIST_HEADER_ID
FROM QP_LIST_HEADERS_B LH
, QP_CURRENCY_DETAILS QCD
WHERE LH.CURRENCY_HEADER_ID = QCD.CURRENCY_HEADER_ID
AND QCD.CONVERSION_TYPE = 'FIXED'
AND (SELECT FND_PROFILE.VALUE('QP_MULTI_CURRENCY_INSTALLED')
FROM DUAL) = 'Y')

Columns