View: CLN_PROCAT_CATALOG_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View containing price list header information for the Sync Catalog XML message
Implementation/DBA Data:	APPS.CLN_PROCAT_CATALOG_V

View Text

SELECT TL.NAME
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, LH.LIST_TYPE_CODE
, LH.LIST_HEADER_ID
, 0 CURRENCY_DETAIL_ID
, LH.CURRENCY_CODE TO_CURRENCY_CODE
, 1 FIXED_VALUE
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LH.LIST_TYPE_CODE IN ('PRL')
AND LH.ACTIVE_FLAG = 'Y' UNION (SELECT TL.NAME
, LH.START_DATE_ACTIVE
, LH.END_DATE_ACTIVE
, LH.COMMENTS
, LH.ACTIVE_FLAG
, LH.LIST_TYPE_CODE
, LH.LIST_HEADER_ID
, QCD.CURRENCY_DETAIL_ID
, QCD.TO_CURRENCY_CODE
, QCD.FIXED_VALUE
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
, QP_CURRENCY_DETAILS QCD
WHERE LH.LIST_HEADER_ID = TL.LIST_HEADER_ID
AND TL.LANGUAGE = USERENV('LANG')
AND LH.LIST_TYPE_CODE IN ('PRL')
AND LH.ACTIVE_FLAG = 'Y'
AND LH.CURRENCY_HEADER_ID = QCD.CURRENCY_HEADER_ID)

Columns