How to connect in database tables the shipment line transaction with the receipt transaction
Question: How to connect in database tables the shipment line transaction with the receipt transaction in Review Completed Transaction
I have in the table WSH_DELIVERY_DETAILS the shipment lines for the TRX_BUSINESS_CATEGORY "SALES_TRANSACTION".
Now I need from the material receipt transactions the reference_number in the print DeliveryNote.
I can fetch in the table INV_MATERIAL_TXNS with a join to table INV_TRANSACTION_LOT_NUMBERS all material receipt transactions for the INVENTORY_ITEM_ID and LOT_NUMBER:
select imt.transaction_reference ,itln.transaction_id,itln.lot_number,imt.inventory_item_id
from INV_TRANSACTION_LOT_NUMBERS itln