VIEW: APPS.QP_PRICING_ATTR_V

Source

View Text - Preformatted

SELECT ql.rowid row_id ,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.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 ,ql.LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE ,ql.ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR ,ql.OPERAND OPERAND ,ql.PRICE_BY_FORMULA_ID PRICE_BY_FORMULA_ID ,ql.REBATE_TRANSACTION_TYPE_CODE REBATE_TRANSACTION_TYPE_CODE ,ql.ESTIM_ACCRUAL_RATE ESTIM_ACCRUAL_RATE ,ql.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 ,qpa.comparison_operator_code comparison_operator_code ,ql.list_header_id list_header_id ,ql.proration_type_code proration_type_code ,ql.benefit_qty benefit_qty ,ql.benefit_uom_code benefit_uom_code ,ql.accrual_conversion_rate accrual_conversion_rate ,qr.from_rltd_modifier_id parent_list_line_id ,qr.rltd_modifier_grp_no rltd_modifier_grp_no ,qr.rltd_modifier_grp_type rltd_modifier_grp_type ,qr.rltd_modifier_id rltd_modifier_id ,qr.to_rltd_modifier_id to_rltd_modifier_id ,qpa.product_attribute_datatype product_attribute_datatype ,qpa.pricing_attribute_datatype pricing_attribute_datatype ,ql.list_line_no ,ql.pricing_group_sequence ,ql.incompatibility_grp_code ,ql.pricing_phase_id ,ql.automatic_flag ,ql.override_flag ,ql.print_on_invoice_flag ,ql.price_break_type_code ,ql.modifier_level_code ,ql.accrual_flag ,ql.benefit_limit from qp_list_lines ql, qp_pricing_attributes qpa, qp_rltd_modifiers qr WHERE ql.list_line_id = qpa.list_line_id and ql.list_line_type_code = 'RLTD' and ql.list_line_id = qr.to_rltd_modifier_id and qr.rltd_modifier_grp_type = 'QUALIFIER'

View Text - HTML Formatted

SELECT QL.ROWID ROW_ID
, 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.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
, QL.LIST_LINE_TYPE_CODE LIST_LINE_TYPE_CODE
, QL.ARITHMETIC_OPERATOR ARITHMETIC_OPERATOR
, QL.OPERAND OPERAND
, QL.PRICE_BY_FORMULA_ID PRICE_BY_FORMULA_ID
, QL.REBATE_TRANSACTION_TYPE_CODE REBATE_TRANSACTION_TYPE_CODE
, QL.ESTIM_ACCRUAL_RATE ESTIM_ACCRUAL_RATE
, QL.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
, QPA.COMPARISON_OPERATOR_CODE COMPARISON_OPERATOR_CODE
, QL.LIST_HEADER_ID LIST_HEADER_ID
, QL.PRORATION_TYPE_CODE PRORATION_TYPE_CODE
, QL.BENEFIT_QTY BENEFIT_QTY
, QL.BENEFIT_UOM_CODE BENEFIT_UOM_CODE
, QL.ACCRUAL_CONVERSION_RATE ACCRUAL_CONVERSION_RATE
, QR.FROM_RLTD_MODIFIER_ID PARENT_LIST_LINE_ID
, QR.RLTD_MODIFIER_GRP_NO RLTD_MODIFIER_GRP_NO
, QR.RLTD_MODIFIER_GRP_TYPE RLTD_MODIFIER_GRP_TYPE
, QR.RLTD_MODIFIER_ID RLTD_MODIFIER_ID
, QR.TO_RLTD_MODIFIER_ID TO_RLTD_MODIFIER_ID
, QPA.PRODUCT_ATTRIBUTE_DATATYPE PRODUCT_ATTRIBUTE_DATATYPE
, QPA.PRICING_ATTRIBUTE_DATATYPE PRICING_ATTRIBUTE_DATATYPE
, QL.LIST_LINE_NO
, QL.PRICING_GROUP_SEQUENCE
, QL.INCOMPATIBILITY_GRP_CODE
, QL.PRICING_PHASE_ID
, QL.AUTOMATIC_FLAG
, QL.OVERRIDE_FLAG
, QL.PRINT_ON_INVOICE_FLAG
, QL.PRICE_BREAK_TYPE_CODE
, QL.MODIFIER_LEVEL_CODE
, QL.ACCRUAL_FLAG
, QL.BENEFIT_LIMIT
FROM QP_LIST_LINES QL
, QP_PRICING_ATTRIBUTES QPA
, QP_RLTD_MODIFIERS QR
WHERE QL.LIST_LINE_ID = QPA.LIST_LINE_ID
AND QL.LIST_LINE_TYPE_CODE = 'RLTD'
AND QL.LIST_LINE_ID = QR.TO_RLTD_MODIFIER_ID
AND QR.RLTD_MODIFIER_GRP_TYPE = 'QUALIFIER'