You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

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

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!