SELECT qph.list_header_id,
qph.name,qph.description,
qphh.start_date_active,
qphh.currency_code,
qphh.source_system_code,
qphh.active_flag,
qphh.orig_system_header_ref,
qphh.orig_org_id,
qphh.global_flag,
qpl.list_line_id,
qpl.start_date_active,
qpl.end_date_active,
qpl.arithmetic_operator,
qpl.operand,
qpl.orig_sys_line_ref,
qpp.pricing_attribute_id,
qpp.product_attribute_context,
qpp.product_attribute,
qpp.product_attr_value,
qpp.product_uom_code,
qpp.comparison_operator_code,
qpp.orig_sys_pricing_attr_ref,
mtl.inventory_item_id,
mtl.segment1,
mtlc.cross_reference_type,
mtlc.cross_reference
FROM apps.qp_list_headers_b qphh,
apps.qp_list_headers_tl qph,
apps.qp_list_lines qpl,
apps.qp_pricing_attributes qpp,
apps.mtl_system_items_b mtl,
apps.mtl_cross_references_b mtlc
WHERE qph.list_header_id = qphh.list_header_id
AND qph.list_header_id = qpl.list_header_id
AND qph.list_header_id = qpp.list_header_id
AND qpl.list_line_id = qpp.list_line_id
AND to_char(mtl.inventory_item_id) = (qpp.product_attr_value)
-- AND mtl.organization_id = 344
-- (SELECT UNIQUE master_organization_id FROM mtl_parameters)
AND mtl.inventory_item_id = mtlc.inventory_item_id
AND SYSDATE BETWEEN qpl.start_date_active
AND NVL (qpl.end_date_active, SYSDATE)
AND SYSDATE BETWEEN qphh.start_date_active
AND NVL (qphh.end_date_active, SYSDATE)
and qph.name like '%SG%'
AND qpl.END_DATE_ACTIVE IS NULL
AND mtl.segment1 = '9780749172008';
select * from mtl_system_items_b where segment1='A101708534498'
