VIEW: APPS.QP_PRICING_ATTR_GET_V

Source

View Text - Preformatted

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 ,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 ,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 ,ql.service_duration ,ql.service_period 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'

View Text - HTML Formatted

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
, 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
, 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
, QL.SERVICE_DURATION
, QL.SERVICE_PERIOD
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'