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.WMS_WAVE_PLANNING_PVT dependencies on MTL_TRANSACTION_LOTS_TEMP

Line 4851: FROM mtl_transaction_lots_temp

4847: WHERE l_delMMTTserialctrl(i) IN (2, 5)
4848: AND ((l_delMMTTlotctrl(i) <> 2 AND (group_mark_id = l_delMMTTtempid(i) OR group_mark_id = l_delMMTThdrid(i)))
4849: OR (l_delMMTTlotctrl(i) = 2
4850: AND (group_mark_id IN (SELECT serial_transaction_temp_id
4851: FROM mtl_transaction_lots_temp
4852: WHERE transaction_temp_id = l_delMMTTtempid(i))
4853: OR group_mark_id = l_delMMTThdrid(i))));
4854:
4855:

Line 4870: FROM mtl_transaction_lots_temp

4866: AND ((l_delMMTTlotctrl(i) <> 2
4867: AND transaction_temp_id = l_delMMTTtempid(i))
4868: OR (l_delMMTTlotctrl(i) = 2
4869: AND transaction_temp_id IN (SELECT SERIAL_TRANSACTION_TEMP_ID
4870: FROM mtl_transaction_lots_temp
4871: WHERE transaction_temp_id = l_delMMTTtempid(i))));
4872:
4873: print_debug(SQL%ROWCOUNT|| ' Rows deleted from MSNT ',l_debug);
4874:

Line 4879: DELETE FROM mtl_transaction_lots_temp

4875:
4876: --FORALL i IN 1 ..l_tbl_count dbchange6
4877:
4878: FORALL i IN l_delMMTTtempid.FIRST ..l_delMMTTtempid.LAST
4879: DELETE FROM mtl_transaction_lots_temp
4880: WHERE l_delMMTTlotctrl(i) = 2
4881: AND transaction_temp_id = l_delMMTTtempid(i);
4882:
4883: print_debug(SQL%ROWCOUNT || ' Rows deleted from MTLT ',l_debug);