Retrieve the Price Lists where a specific Inventory Item exists
select distinct
qplt.name,qmr.*
from fusion.qp_price_lists_all_b qplab,
fusion.qp_price_list_items qpli,
fusion.qp_price_lists_tl qplt,
fusion.qp_price_list_charges qplc,
fusion.qp_matrix_rules qmr
where qpli.price_list_id= qplt.price_list_id
and qplt.language = 'US'
and qpli.item_level_code='ITEM'
AND QPLI.ITEM_ID='PROVIDE INVENTORY_ITEM_ID'
and qplt.price_list_id = qplab.price_list_id
and qplc.parent_entity_id (+) = qpli.price_list_item_id
and qplt.price_list_id = qplc.price_list_id
and qplc.attribute_pricing_matrix_id = qmr.dynamic_matrix_id
and qplt.name='PROVIDE PRICE LIST NAME'
