View: QP_LIST_LINES_V

Product:	QP - Advanced Pricing
Description:	Price List Lines information - used for List Lines block in Price Lists form.
Implementation/DBA Data:	APPS.QP_LIST_LINES_V

View Text

SELECT QPLL.ROWID
, QPLL.LIST_LINE_ID
, QPLL.CREATION_DATE
, QPLL.CREATED_BY
, QPLL.LAST_UPDATE_DATE
, QPLL.LAST_UPDATED_BY
, QPLL.LAST_UPDATE_LOGIN
, QPLL.PROGRAM_APPLICATION_ID
, QPLL.PROGRAM_ID
, QPLL.PROGRAM_UPDATE_DATE
, QPLL.REQUEST_ID
, QPLL.LIST_HEADER_ID
, QPPR.LIST_HEADER_ID PA_LIST_HEADER_ID
, QPPR.PRODUCT_ATTRIBUTE_CONTEXT
, QPPR.PRODUCT_ATTRIBUTE
, QPPR.PRODUCT_ATTR_VALUE
, QPPR.PRODUCT_UOM_CODE
, QPLL.LIST_PRICE
, QPLL.PERCENT_PRICE
, QPLL.PRICE_BY_FORMULA_ID
, QPLL.START_DATE_ACTIVE
, QPLL.END_DATE_ACTIVE
, QPLL.CONTEXT
, QPLL.ATTRIBUTE1
, QPLL.ATTRIBUTE2
, QPLL.ATTRIBUTE3
, QPLL.ATTRIBUTE4
, QPLL.ATTRIBUTE5
, QPLL.ATTRIBUTE6
, QPLL.ATTRIBUTE7
, QPLL.ATTRIBUTE8
, QPLL.ATTRIBUTE9
, QPLL.ATTRIBUTE10
, QPLL.ATTRIBUTE11
, QPLL.ATTRIBUTE12
, QPLL.ATTRIBUTE13
, QPLL.ATTRIBUTE14
, QPLL.ATTRIBUTE15
, QPLL.PRIMARY_UOM_FLAG
, QPLL.REVISION
, QPLL.REVISION_DATE
, QPLL.REVISION_REASON_CODE
, QPLL.COMMENTS
, QPLL.LIST_LINE_TYPE_CODE
, QPLL.AUTOMATIC_FLAG
, QPLL.MODIFIER_LEVEL_CODE
, QPLL.LIST_PRICE_UOM_CODE
, QPLL.INVENTORY_ITEM_ID
, QPLL.ORGANIZATION_ID
, QPLL.RELATED_ITEM_ID
, QPLL.NUMBER_EFFECTIVE_PERIODS
, QPLL.EFFECTIVE_PERIOD_UOM
, QPLL.ARITHMETIC_OPERATOR
, QPLL.INCOMPATIBILITY_GRP_CODE
, QPLL.LIST_LINE_NO
, QPLL.PRICING_GROUP_SEQUENCE
, QPLL.RELATIONSHIP_TYPE_ID
, QPLL.SUBSTITUTION_CONTEXT
, QPLL.SUBSTITUTION_ATTRIBUTE
, QPLL.SUBSTITUTION_VALUE
, QPLL.PRICE_BREAK_TYPE_CODE
, QPLL.OPERAND
, QPLL.OVERRIDE_FLAG
, QPLL.PRINT_ON_INVOICE_FLAG
, QPLL.REBATE_TRANSACTION_TYPE_CODE
, QPLL.BASE_QTY
, QPLL.BASE_UOM_CODE
, QPLL.ACCRUAL_QTY
, QPLL.ACCRUAL_UOM_CODE
, QPLL.ESTIM_ACCRUAL_RATE
, QPLL.GENERATE_USING_FORMULA_ID
, QPLL.ACCRUAL_FLAG
, QPLL.REPRICE_FLAG
, QPLL.PRICING_PHASE_ID
, QPLL.PRODUCT_PRECEDENCE
, QPPR.PRICING_ATTRIBUTE_CONTEXT
, QPPR.PRICING_ATTRIBUTE
, QPPR.PRICING_ATTR_VALUE_FROM
, QPPR.PRICING_ATTR_VALUE_TO
, QP_PRICE_LIST_LINE_UTIL.GET_PRODUCT_VALUE('QP_ATTR_DEFNS_PRICING'
, QPPR.PRODUCT_ATTRIBUTE_CONTEXT
, QPPR.PRODUCT_ATTRIBUTE
, QPPR.PRODUCT_ATTR_VALUE)
, DECODE(UPPER(QPPR.PRODUCT_ATTR_VALUE)
, 'ALL'
, NULL
, QPPR.PRODUCT_ATTR_VALUE)
, QPPR.PRICING_ATTRIBUTE_ID
, QPPR.PRODUCT_ATTRIBUTE_DATATYPE
, QPPR.PRICING_ATTRIBUTE_DATATYPE
, QPPR.COMPARISON_OPERATOR_CODE
, QPPR.LIST_LINE_ID
, QPPR.CREATION_DATE
, QPPR.CREATED_BY
, QPPR.LAST_UPDATE_DATE
, QPPR.LAST_UPDATED_BY
, QPPR.LAST_UPDATE_LOGIN
, QPPR.PROGRAM_APPLICATION_ID
, QPPR.PROGRAM_ID
, QPPR.PROGRAM_UPDATE_DATE
, QPPR.REQUEST_ID
, QPPR.CONTEXT
, QPPR.ATTRIBUTE1
, QPPR.ATTRIBUTE2
, QPPR.ATTRIBUTE3
, QPPR.ATTRIBUTE4
, QPPR.ATTRIBUTE5
, QPPR.ATTRIBUTE6
, QPPR.ATTRIBUTE7
, QPPR.ATTRIBUTE8
, QPPR.ATTRIBUTE9
, QPPR.ATTRIBUTE10
, QPPR.ATTRIBUTE11
, QPPR.ATTRIBUTE12
, QPPR.ATTRIBUTE13
, QPPR.ATTRIBUTE14
, QPPR.ATTRIBUTE15
FROM QP_LIST_LINES QPLL
, QP_PRICING_ATTRIBUTES QPPR
WHERE QPPR.LIST_LINE_ID = QPLL.LIST_LINE_ID
AND QPLL.LIST_LINE_TYPE_CODE IN ('PLL'
, 'PBH')
AND QPPR.PRICING_PHASE_ID = 1
AND QPPR.QUALIFICATION_IND IN (4
, 6
, 20
, 22)
AND QPLL.LIST_LINE_ID NOT IN ( SELECT TO_RLTD_MODIFIER_ID
FROM QP_RLTD_MODIFIERS)
AND ( ( QPPR.ROWID = ( SELECT ROWID
FROM QP_PRICING_ATTRIBUTES
WHERE QPPR.LIST_LINE_ID = LIST_LINE_ID
AND PRICING_ATTRIBUTE_CONTEXT = 'PRICING_ATTRIBUTE'
AND PRICING_ATTRIBUTE = 'PRICING_ATTRIBUTE3' ) ) OR ( QPPR.ROWID = ( SELECT ROWID
FROM QP_PRICING_ATTRIBUTES
WHERE QPPR.LIST_LINE_ID = LIST_LINE_ID
AND ROWNUM < 2 )
AND NOT EXISTS ( SELECT NULL
FROM QP_PRICING_ATTRIBUTES
WHERE QPPR.LIST_LINE_ID = LIST_LINE_ID
AND PRICING_ATTRIBUTE_CONTEXT = 'PRICING_ATTRIBUTE'
AND PRICING_ATTRIBUTE = 'PRICING_ATTRIBUTE3' ) ) )

Columns