Need to get reason code from database for backordered transfer orders
Summary:
Trying to write a query from INV_MATERIAL_TXNS to inv_material_txns_exceptions and INV_TRANSACTION_REASONS_TL to get the reason code but I cannot find the link. I get no data using this: select imte.* from inv_material_txns_exceptions imte, INV_MATERIAL_TXNS imt
where imte.transaction_id = imt.transaction_id
Does anyone know how to link a pick confirm backorder transaction to the table that store the reason codes even if INV_MATERIAL_TXNS is not the correct starting point?
Content (please ensure you mask any confidential information):
This is the transaction the user is performing:
0