View: CLN_PROCAT_PRICE_LISTS_V

Product:	CLN - Supply Chain Trading Connector for RosettaNet
Description:	View of the available price lists
Implementation/DBA Data:	APPS.CLN_PROCAT_PRICE_LISTS_V

View Text

SELECT TL.NAME NAME
, LH.LIST_HEADER_ID LIST_HEADER_ID
, HCA.PARTY_ID PARTY_ID
, 'Y' ASSIGNED_FLAG
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
, QPBV_QUALIFIERS QQ
, HZ_CUST_ACCOUNTS HCA
WHERE TL.LIST_HEADER_ID = LH.LIST_HEADER_ID
AND QQ.LIST_HEADER_ID = LH.LIST_HEADER_ID
AND QQ.QUALIFIER_ATTR_VALUE = HCA.CUST_ACCOUNT_ID
AND LH.LIST_TYPE_CODE = 'PRL'
AND QQ.QUALIFIER_CONTEXT = 'CUSTOMER'
AND QQ.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE2'
AND TL.LANGUAGE = USERENV('LANG')
AND ((NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND (SELECT FND_PROFILE.VALUE('ORG_ID')
FROM DUAL) = LH.ORIG_ORG_ID) OR (NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND NVL(LH.GLOBAL_FLAG
, 'Y') = 'Y') OR NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'OFF') UNION (SELECT TL.NAME NAME
, LH.LIST_HEADER_ID LIST_HEADER_ID
, -1 PARTY_ID
, 'N' ASSIGNED_FLAG
FROM QP_LIST_HEADERS_B LH
, QP_LIST_HEADERS_TL TL
WHERE TL.LIST_HEADER_ID = LH.LIST_HEADER_ID
AND LH.LIST_TYPE_CODE = 'PRL'
AND TL.LANGUAGE = USERENV('LANG')
AND ((NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND (SELECT FND_PROFILE.VALUE('ORG_ID')
FROM DUAL) = LH.ORIG_ORG_ID) OR (NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'ON'
AND NVL(LH.GLOBAL_FLAG
, 'Y') = 'Y') OR NVL((SELECT FND_PROFILE.VALUE('QP_SECURITY_CONTROL')
FROM DUAL)
, 'OFF') = 'OFF'))

Columns