QP Modifier Details (1)

SELECT a.list_line_id,a.list_header_id list_header_id2,a.list_line_type_code,a.list_line_type,a.start_date_active,a.end_date_active,
                          a.automatic_flag,a.modifier_level,a.price_break_type,a.arithmetic_operator_type,
                          a.override_flag,a.print_on_invoice_flag,a.formula,a.incompatibility_grp,
                          a.list_line_no,a.pricing_phase,a.estim_gl_value,a.proration_type,
                          a.pricing_group_sequence,a.operand,a.accrual_flag,a.charge_name,a.include_on_returns_flag,
                          a.related_item,a.substitution_attribute,a.substitution_value,a.charge_subtype_code,
                          a.expiration_date,a.expiration_period_start_date,a.number_expiration_periods,
                          a.expiration_period_uom,a.benefit_qty,a.benefit_uom_code,a.estim_accrual_rate,
                          a.accrual_conversion_rate,a.product_precedence,product_attribute_type,product_attr_value,
                          a.pricing_attr_value_from,a.pricing_attr_value_to,a.pricing_attribute,a.product_uom_code,
                          a.comparison_operator_code ,a.net_amount_flag, a.accum_attribute,
                QP_QPXPRMLS_XMLP_PKG.cf_net_amount_calcformula(a.net_amount_flag) CF_NET_AMOUNT_CALC,
                QP_QPXPRMLS_XMLP_PKG.cf_coup_list_lineformula(a.list_line_id) CF_coup_list_line
            FROM   qp_modifier_summary_v a
            WHERE a.list_line_type_code IN ('DIS', 'OID', 'TSN', 'CIE', 'PBH', 'IUE', 'SUR', 'FREIGHT_CHARGE', 'PRG') AND      NOT EXISTS (SELECT NULL
                                                  FROM qp_rltd_modifiers q
                                                 WHERE a.list_line_id  = q.to_rltd_modifier_id
                                                  )
            &LP_ACTIVE_MODIFIER_LINES_ONLY
             and a.list_header_id = :list_header_id10
            ORDER BY a.list_line_no