VIEW: APPS.QPBV_PRODUCT_BENEFITS

Source

View Text - Preformatted

SELECT pa.LIST_LINE_ID ,pa.LIST_HEADER_ID ,pa.PRODUCT_ATTRIBUTE_CONTEXT ,pa.PRODUCT_ATTRIBUTE ,pa.PRODUCT_ATTR_VALUE ,ll2.OPERAND ,ll2.LIST_LINE_ID ,ll1.OPERAND ,ll1.BENEFIT_QTY ,ll1.ARITHMETIC_OPERATOR ,ll1.BENEFIT_UOM_CODE ,pa.PRODUCT_UOM_CODE ,pa.PRICING_ATTRIBUTE_ID ,pa.CREATION_DATE ,pa.CREATED_BY ,pa.LAST_UPDATE_DATE ,pa.LAST_UPDATED_BY ,ll1. ORIG_SYS_HEADER_REF ,ll1.ORIG_SYS_LINE_REF , pa.ORIG_SYS_PRICING_ATTR_REF from qp_rltd_modifiers rltd, qp_list_lines ll1, qp_list_lines ll2, qp_pricing_attributes pa WHERE rltd.rltd_modifier_grp_type = 'BENEFIT' and rltd.to_rltd_modifier_id = pa.list_line_id and rltd.to_rltd_modifier_id = ll1.list_line_id and ll1.benefit_price_list_line_id = ll2.list_line_id and pa.excluder_flag = 'N'

View Text - HTML Formatted

SELECT PA.LIST_LINE_ID
, PA.LIST_HEADER_ID
, PA.PRODUCT_ATTRIBUTE_CONTEXT
, PA.PRODUCT_ATTRIBUTE
, PA.PRODUCT_ATTR_VALUE
, LL2.OPERAND
, LL2.LIST_LINE_ID
, LL1.OPERAND
, LL1.BENEFIT_QTY
, LL1.ARITHMETIC_OPERATOR
, LL1.BENEFIT_UOM_CODE
, PA.PRODUCT_UOM_CODE
, PA.PRICING_ATTRIBUTE_ID
, PA.CREATION_DATE
, PA.CREATED_BY
, PA.LAST_UPDATE_DATE
, PA.LAST_UPDATED_BY
, LL1. ORIG_SYS_HEADER_REF
, LL1.ORIG_SYS_LINE_REF
, PA.ORIG_SYS_PRICING_ATTR_REF
FROM QP_RLTD_MODIFIERS RLTD
, QP_LIST_LINES LL1
, QP_LIST_LINES LL2
, QP_PRICING_ATTRIBUTES PA
WHERE RLTD.RLTD_MODIFIER_GRP_TYPE = 'BENEFIT'
AND RLTD.TO_RLTD_MODIFIER_ID = PA.LIST_LINE_ID
AND RLTD.TO_RLTD_MODIFIER_ID = LL1.LIST_LINE_ID
AND LL1.BENEFIT_PRICE_LIST_LINE_ID = LL2.LIST_LINE_ID
AND PA.EXCLUDER_FLAG = 'N'