lot genealogy sql query
1) we are using lot enabled item codes for production batches and inventory transactions.2) we are using following tables for lot genealogy or hierarchy records
MTL_OBJECT_GENEALOGY MOG, MTL_LOT_NUMBERS MLN, MTL_TRANSACTION_LOT_NUMBERS MTLN, MTL_MATERIAL_TRANSACTIONS MMT, GME_BATCH_HEADER GBH, GMD_ROUTINGS_B GR
3) we have found that some data in the fields MMT.TRANSACTION_ID = MOG.ORIGIN_TXN_ID doesn't match sometimes
i.e. transaction_id from mtl_material_transaction and origin_txn_id from doean't match somes times
either we are doing wrong joining or table is not getting updated properly in some transactions
MTL_OBJECT_GENEALOGY MOG, MTL_LOT_NUMBERS MLN, MTL_TRANSACTION_LOT_NUMBERS MTLN, MTL_MATERIAL_TRANSACTIONS MMT, GME_BATCH_HEADER GBH, GMD_ROUTINGS_B GR
3) we have found that some data in the fields MMT.TRANSACTION_ID = MOG.ORIGIN_TXN_ID doesn't match sometimes
i.e. transaction_id from mtl_material_transaction and origin_txn_id from doean't match somes times
either we are doing wrong joining or table is not getting updated properly in some transactions
0