SELECT mr.transaction_id
,mpo.delivery_balance
FROM mrp_item_purchase_orders mpo
,mrp_recommendationsmr
WHERE mr.disposition_id = mpo.transaction_id
AND mr.compile_designator = mpo.compile_designator
AND mr.organization_id = mpo.organization_id
AND mr.inventory_item_id = mpo.inventory_item_id
AND mpo.purchase_order_id = :req_header_id
AND mpo.order_type = 2
AND mpo.purch_line_num = :req_line_num;