View: QPBV_SECONDARY_PRICE_LISTS

Product:	QP - Advanced Pricing
Description:	This view gives information about Primary Price list and its Secondary Price list.
Implementation/DBA Data:	APPS.QPBV_SECONDARY_PRICE_LISTS

View Text

SELECT TL2.NAME
, TL2.LIST_HEADER_ID
, TL1.NAME
, TL1.LIST_HEADER_ID
, QUAL.QUALIFIER_PRECEDENCE
, TL1.CREATION_DATE
, TL1.CREATED_BY
, TL1.LAST_UPDATE_DATE
, TL1.LAST_UPDATED_BY
FROM QP_LIST_HEADERS_TL TL1
, QP_LIST_HEADERS_TL TL2
, QP_QUALIFIERS QUAL
WHERE QUAL.LIST_HEADER_ID = TL1.LIST_HEADER_ID
AND TL1.LANGUAGE = USERENV('LANG')
AND TL2.LANGUAGE = USERENV('LANG')
AND QUAL.LIST_TYPE_CODE IN ('PRL'
, 'AGR')
AND QUAL.QUALIFIER_CONTEXT = 'MODLIST'
AND QUAL.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4'
AND TL2.LIST_HEADER_ID = FND_NUMBER.CANONICAL_TO_NUMBER(QUAL.QUALIFIER_ATTR_VALUE)

Columns