DBA Data[Home] [Help]

APPS.INV_INVLTATT_XMLP_PKG dependencies on MTL_TRANSACTION_LOTS_INTERFACE

Line 233: mtl_transaction_lots_interface mtli

229: and mmtt.inventory_item_id = mln.inventory_item_id
230: and mtlt.lot_number = mln.lot_number)
231: AND not exists(select 'x'
232: from mtl_transactions_interface mti,
233: mtl_transaction_lots_interface mtli
234: where mti.transaction_interface_id = mtli.transaction_interface_id
235: and mti.organization_id = mln.organization_id
236: and mti.inventory_item_id = mln.inventory_item_id
237: and mtli.lot_number = mln.lot_number)

Line 414: mtl_transaction_lots_interface mtli

410: and mmtt.inventory_item_id = mln.inventory_item_id
411: and mtlt.lot_number = mln.lot_number)
412: AND not exists(select 'x'
413: from mtl_transactions_interface mti,
414: mtl_transaction_lots_interface mtli
415: where mti.transaction_interface_id = mtli.transaction_interface_id
416: and mti.organization_id = mln.organization_id
417: and mti.inventory_item_id = mln.inventory_item_id
418: and mtli.lot_number = mln.lot_number)