[Home] [Help]
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
Name |
CURRENCY_CODE |
CURRENCY_DETAIL_ID |
LIST_HEADER_ID |