Modifiers At Line Level

SELECT qlh.comments "Modifier Name"
      ,qms.product_attr_value "SKU"
      ,qms.list_line_no "Modifier Line No"
      ,qms.start_date_active
      ,qms.end_date_active
      ,qms.arithmetic_operator_type "Application Method"
      ,qms.operand "Value"
      ,qms.product_precedence
      ,qms.incompatibility_grp
      ,qms.pricing_group_sequence "Bucket"
  FROM qp_modifier_summary_v qms
      ,qp_list_headers_b qlh
 WHERE qlh.list_header_id = qms.list_header_id
   AND EXISTS(SELECT 1
                FROM mtl_system_items_b a
               WHERE a.organization_id = 22 AND TO_CHAR(a.inventory_item_id) = qms.product_attr_val AND a.segment1 IN('61579702') )