oracle-ebs-modifier-applied-against-so
SELECT a.NAME “Modifier Name”,b.INVENTORY_ITEM_ID,
b.list_line_no “Modifier Line No”,
a.description “Modifier Description”,
a.comments,
b.list_line_type_code,
d.qualifier_context,
a.orig_org_id,
a.active_flag,
b.start_date_active,
b.end_date_active,
a.list_type_code,
b.modifier_level_code,
b.organization_id,
f.order_number,
b.pricing_phase_id,
b.last_update_date,
b.list_line_no,
d.header_quals_exist_flag,
d.qualifier_datatype,
d.qualifier_attribute,
d.segment_id,
d.CONTEXT,
d.qualifier_grouping_no
FROM apps.qp_list_headers_all a,
apps.qp_list_lines b,
apps.qp_pricing_attributes c,
apps.qp_qualifiers d,
apps.qp_qualifier_rules qqr,
apps.oe_order_lines_all e,
apps.oe_order_headers_all f
WHERE a.list_header_id = b.list_header_id
AND b.list_header_id = c.list_header_id
AND b.list_line_id = d.list_line_id(+)
AND qqr.qualifier_rule_id(+) = d.created_from_rule_id
AND e.price_list_id(+) = b.list_header_id
AND e.header_id = f.header_id(+)
AND b.list_line_id = c.list_line_id(+)
AND b.pricing_phase_id > 1
AND f.order_number = ‘ORDER_NUMBER’
ORDER BY b.last_update_date DESC;
