eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GMD_QMSMC dependencies on MTL_TRANSACTION_LOT_NUMBERS

Line 187: MTL_TRANSACTION_LOT_NUMBERS L

183: CURSOR inv_lot IS
184: SELECT c.PARENT_LOT_NUMBER, c.LOT_NUMBER
185: FROM MTL_LOT_NUMBERS C,
186: MTL_MATERIAL_TRANSACTIONS M,
187: MTL_TRANSACTION_LOT_NUMBERS L
188: WHERE M.transaction_id = l_trans_id -- replace l_event_key by l_trans_id -- 9756188
189: AND M.inventory_item_id = C.inventory_item_id
190: AND M.organization_id = C.organization_id
191: AND C.LOT_NUMBER = L.LOT_NUMBER

Line 346: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln

342: -- 9756188 new cursor for lot issue
343:
344: CURSOR get_mtln_lot(p_trans_id NUMBER, p_gen_obj_id NUMBER) IS
345: select mtln.lot_number, mln.parent_lot_number,mtln.transaction_quantity, mtln.secondary_transaction_quantity
346: from mtl_transaction_lot_numbers mtln,mtl_lot_numbers mln
347: where mtln.transaction_id = p_trans_id
348: and mln.gen_object_id = p_gen_obj_id
349: and mln.lot_number = mtln.lot_number
350: and mln.inventory_item_id = mtln.inventory_item_id