View: QP_PRICING_ATTR_GET_V

Product:	QP - Advanced Pricing
Description:	View of Benefit or Get Products for a Modifier. Used by Modifiers Form.
Implementation/DBA Data:	APPS.QP_PRICING_ATTR_GET_V

View Text

SELECT QL.ROWID ROW_ID
, QPA.COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR_CODE
, QPA.PRICING_ATTRIBUTE_ID PRICING_ATTRIBUTE_ID
, QPA.CREATION_DATE CREATION_DATE
, QPA.CREATED_BY CREATED_BY
, QPA.LAST_UPDATE_DATE LAST_UPDATE_DATE
, QPA.LAST_UPDATED_BY LAST_UPDATED_BY
, QPA.LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, QPA.PROGRAM_APPLICATION_ID PROGRAM_APPLICATION_ID
, QPA.PROGRAM_ID PROGRAM_ID
, QPA.PROGRAM_UPDATE_DATE PROGRAM_UPDATE_DATE
, QPA.REQUEST_ID REQUEST_ID
, QPA.LIST_LINE_ID LIST_LINE_ID
, QPA.EXCLUDER_FLAG EXCLUDER_FLAG
, QPA.PRODUCT_ATTRIBUTE_CONTEXT PRODUCT_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE PRODUCT_ATTRIBUTE
, QPA.PRODUCT_ATTR_VALUE PRODUCT_ATTR_VALUE
, QPA.PRODUCT_UOM_CODE PRODUCT_UOM_CODE
, QPA.PRICING_ATTRIBUTE_CONTEXT PRICING_ATTRIBUTE_CONTEXT
, QPA.PRODUCT_ATTRIBUTE_DATATYPE PRODUCT_ATTRIBUTE_DATATYPE
, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE
, QPA.PRICING_ATTRIBUTE PRICING_ATTRIBUTE
, QPA.PRICING_ATTR_VALUE_FROM PRICING_ATTR_VALUE_FROM
, QPA.PRICING_ATTR_VALUE_TO PRICING_ATTR_VALUE_TO
, QPA.ATTRIBUTE_GROUPING_NO ATTRIBUTE_GROUPING_NO
, QPA.CONTEXT CONTEXT
, QL.ATTRIBUTE1 ATTRIBUTE1
, QL.ATTRIBUTE2 ATTRIBUTE2
, QL.ATTRIBUTE3 ATTRIBUTE3
, QL.ATTRIBUTE4 ATTRIBUTE4
, QL.ATTRIBUTE5 ATTRIBUTE5
, QL.ATTRIBUTE6 ATTRIBUTE6
, QL.ATTRIBUTE7 ATTRIBUTE7
, QL.ATTRIBUTE8 ATTRIBUTE8
, QL.ATTRIBUTE9 ATTRIBUTE9
, QL.ATTRIBUTE10 ATTRIBUTE10
, QL.ATTRIBUTE11 ATTRIBUTE11
, QL.ATTRIBUTE12 ATTRIBUTE12
, QL.ATTRIBUTE13 ATTRIBUTE13
, QL.ATTRIBUTE14 ATTRIBUTE14
, QL.ATTRIBUTE15 ATTRIBUTE15
, QL.LIST_LINE_NO LIST_LINE_NO
, QL.LIST_HEADER_ID LIST_HEADER_ID
, QL.LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE
, QL.ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR
, QL.OPERAND OPERAND
, QL.PRORATION_TYPE_CODE PRORATION_TYPE_CODE
, QL.BENEFIT_LIMIT BENEFIT_LIMIT
, QL.BENEFIT_UOM_CODE BENEFIT_UOM_CODE
, QL.AUTOMATIC_FLAG AUTOMATIC_FLAG
, QL.MODIFIER_LEVEL_CODE MODIFIER_LEVEL_CODE
, QL.PRICE_BY_FORMULA_ID PRICE_BY_FORMULA_ID
, QL.PRICING_GROUP_SEQUENCE PRICING_GROUP_SEQUENCE
, QL.PRICING_PHASE_ID PRICING_PHASE_ID
, QL.BENEFIT_PRICE_LIST_LINE_ID BENEFIT_PRICE_LIST_LINE_ID
, QL.BENEFIT_QTY BENEFIT_QTY
, QL.OVERRIDE_FLAG OVERRIDE_FLAG
, QL.PRINT_ON_INVOICE_FLAG PRINT_ON_INVOICE_FLAG
, QRM.RLTD_MODIFIER_GRP_TYPE RLTD_MODIFIER_GRP_TYPE
, QRM.RLTD_MODIFIER_ID RLTD_MODIFIER_ID
, QRM.RLTD_MODIFIER_GRP_NO RLTD_MODIFIER_GRP_NO
, QRM.FROM_RLTD_MODIFIER_ID PARENT_LIST_LINE_ID
, QRM.TO_RLTD_MODIFIER_ID TO_RLTD_MODIFIER_ID
, QL.PRICE_BREAK_TYPE_CODE
FROM QP_LIST_LINES QL
, QP_RLTD_MODIFIERS QRM
, QP_PRICING_ATTRIBUTES QPA
WHERE QL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QPA.LIST_LINE_ID = QRM.TO_RLTD_MODIFIER_ID
AND QRM.RLTD_MODIFIER_GRP_TYPE = 'BENEFIT'

Columns