View: QP_SECONDARY_PRICE_LISTS_V

Product:	QP - Advanced Pricing
Description:	Secondary price lists for each price list. Used for Secondary Price Lists block in Price Lists form.
Implementation/DBA Data:	APPS.QP_SECONDARY_PRICE_LISTS_V

View Text

SELECT QPHB.ROWID
, QPHB.LIST_HEADER_ID
, QP_PRICE_LIST_LINE_UTIL.GET_QUALIFIER_ATTR_VALUE(QPQR.QUALIFIER_ATTR_VALUE)
, QPHB.CREATION_DATE
, QPHB.CREATED_BY
, QPHB.LAST_UPDATE_DATE
, QPHB.LAST_UPDATED_BY
, QPHB.LAST_UPDATE_LOGIN
, QPHB.PROGRAM_APPLICATION_ID
, QPHB.PROGRAM_ID
, QPHB.PROGRAM_UPDATE_DATE
, QPHB.REQUEST_ID
, QPHT.NAME
, QPHT.DESCRIPTION
, QPHB.COMMENTS
, QPQR.QUALIFIER_PRECEDENCE
, QPHB.START_DATE_ACTIVE
, QPHB.END_DATE_ACTIVE
, QPHB.LIST_TYPE_CODE
, QPHB.TERMS_ID
, QPHB.ROUNDING_FACTOR
, QPHB.CURRENCY_CODE
, QPHB.SHIP_METHOD_CODE
, QPHB.FREIGHT_TERMS_CODE
, QPQR.CONTEXT
, QPQR.ATTRIBUTE1
, QPQR.ATTRIBUTE2
, QPQR.ATTRIBUTE3
, QPQR.ATTRIBUTE4
, QPQR.ATTRIBUTE5
, QPQR.ATTRIBUTE6
, QPQR.ATTRIBUTE7
, QPQR.ATTRIBUTE8
, QPQR.ATTRIBUTE9
, QPQR.ATTRIBUTE10
, QPQR.ATTRIBUTE11
, QPQR.ATTRIBUTE12
, QPQR.ATTRIBUTE13
, QPQR.ATTRIBUTE14
, QPQR.ATTRIBUTE15
, QPQR.QUALIFIER_ID
, QPQR.EXCLUDER_FLAG
, QPQR.COMPARISON_OPERATOR_CODE
, QPQR.QUALIFIER_CONTEXT
, QPQR.QUALIFIER_ATTRIBUTE
, QP_PRICE_LIST_LINE_UTIL.GET_QUALIFIER_ATTR_VALUE(QPQR.QUALIFIER_ATTR_VALUE)
, QPQR.QUALIFIER_GROUPING_NO
FROM QP_LIST_HEADERS_B QPHB
, QP_LIST_HEADERS_TL QPHT
, QP_QUALIFIERS QPQR
WHERE QPHB.LIST_HEADER_ID = QPHT.LIST_HEADER_ID
AND QPHT.LANGUAGE = USERENV('LANG')
AND TO_CHAR(QPHB.LIST_HEADER_ID) <> QPQR.QUALIFIER_ATTR_VALUE
AND QPHB.LIST_HEADER_ID = QPQR.LIST_HEADER_ID
AND QPHB.LIST_TYPE_CODE = 'PRL'
AND QPQR.QUALIFIER_RULE_ID IS NULL
AND ( ( QPQR.QUALIFIER_CONTEXT = 'MODLIST'
AND QPQR.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE4') OR ( QPQR.QUALIFIER_CONTEXT = 'ORDER'
AND QPQR.QUALIFIER_ATTRIBUTE = 'QUALIFIER_ATTRIBUTE11') )

Columns