Query to derive qualifier attribute and context based on Modifier name 

Query :

SELECT   c.list_line_no "Modifier Line No", 
 b.name "Modifier Name", 
 b.description  "Modifier Description", 
 a.qualifier_context,  
a.qualifier_attribute,
  a.qualifier_attr_value
FROM qp_qualifiers_v a, 
           qp_list_headers b, 
           qp_list_lines 
WHERE a.list_header_id=b.list_header_id
and c.list_header_id=b.list_header_id
and c.list_line_id = a.list_line_id
and b.name = &Modifier_Name
ORDER BY a.creation_date DESC;