Serials in Transaction History for PO Receipt Number – SQL Query Adjustment Needed

Summary:

Hi Oracle Support,

I am using the query below to retrieve serial numbers for receipt 30148, but it does not show all four serials as seen in the Transaction History UI.

SELECT eib.item_number,
c.receipt_num,
rsl.QUANTITY_RECEIVED,
am.serial_number,
b.transaction_date,
b.po_header_id,
poa.segment1
FROM inv_serial_numbers am,
inv_material_txns imt,
rcv_transactions b,
rcv_shipment_headers c,
egp_system_items_b eib,
inv_transaction_types_tl it,
rcv_shipment_lines rsl,
po_headers_all poa
WHERE am.last_transaction_id (+) = imt.transaction_id
AND imt.rcv_transaction_id (+) = b.transaction_id