DBA Data[Home] [Help]

APPS.MTL_LOT_UOM_CONV_PVT dependencies on GME_TRANSACTION_PAIRS

Line 387: FROM gme_transaction_pairs

383: FROM mtl_material_transactions mmt
384: WHERE transaction_source_id = p_batch_id
385: AND transaction_source_type_id = 5 -- gme_common_pvt.g_txn_source_type
386: AND NOT EXISTS ( SELECT transaction_id1
387: FROM gme_transaction_pairs
388: WHERE transaction_id1 = mmt.transaction_id
389: AND pair_type = 1) --gme_common_pvt.g_pairs_reversal_type
390: AND inventory_item_id = p_lot_uom_conv_rec.inventory_item_id
391: AND organization_id = p_lot_uom_conv_rec.organization_id