Price List and Charges for an Inventory Item

SELECT INVENTORY_ITEM_ID, ORGANIZATION_ID, item_number 
 FROM egp_system_items_b 
 WHERE item_number = '&ITEM_NUMBER'; 
  
 SELECT 
     qplt.PRICE_LIST_ID, 
     qplt.name, 
     qpli.item_id, 
     qpli.PRICE_LIST_ITEM_ID, 
     qpli.PRICE_LIST_ID, 
     qpli.LINE_TYPE_CODE, 
     qpli.ITEM_LEVEL_CODE, 
     qpli.ITEM_ID, 
     qpli.PRICING_UOM_CODE, 
     qpli.PRIMARY_PRICING_UOM_FLAG, 
     qplc.PRICE_LIST_CHARGE_ID, 
     qplc.PRICING_BASIS_ID, 
     qplc.CHARGE_LINE_NUMBER, 
     qplc.START_DATE, 
     qplc.TIER_CONTEXT_CODE, 
     qplc.CHARGE_DEFINITION_ID, 
     qplc.PARENT_ENTITY_TYPE_CODE, 
     qplc.PARENT_ENTITY_ID, 
     qplc.BASE_PRICE, 
     qplc.USAGE_UOM_CODE, 
     qplc.PRICE_PERIODICITY_CODE, 
     qplc.CAN_ADJUST_FLAG, 
     qplc.END_DATE, 
     qplc.TIERED_PRICING_HEADER_ID, 
     qplc.ATTRIBUTE_PRICING_MATRIX_ID, 
     qplc.CALCULATION_METHOD_CODE, 
     qplc.CALCULATION_TYPE_CODE, 
     qplc.COST_CALCULATION_AMOUNT, 
     qplc.PRICE_LIST_ID 
 FROM 
     QP_PRICE_LISTS_TL qplt, 
     QP_PRICE_LIST_ITEMS qpli, 
     qp_price_list_charges qplc 
 WHERE 
     qplt.PRICE_LIST_ID = qpli.PRICE_LIST_ID 
     AND qplc.parent_entity_id(+) = qpli.PRICE_LIST_ITEM_ID 
     AND qpli.item_id = :INVENTORY_ITEM_ID 
 ORDER BY qplt.name, qpli.PRICE_LIST_ID, qpli.PRICE_LIST_ITEM_ID;