Price Adjustments Matrix in Price List

-- 1) Get Inventory Item ID 
 SELECT DISTINCT INVENTORY_ITEM_ID 
 FROM EGP_SYSTEM_ITEMS_B 
 WHERE item_number='Provide_Item_Number'; 
  
 -- 2) Provide Price List Name and INVENTORY_ITEM_ID obtained above 
 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';