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_SERIAL_NUMBERS

Line 4845: UPDATE mtl_serial_numbers

4841: l_tbl_count := l_delMMTTtempid.Count;
4842: IF l_delMMTTtempid.Count >0 THEN
4843: FORALL i IN l_delMMTTtempid.FIRST ..l_delMMTTtempid.LAST
4844: --FOR i IN 1 ..l_tbl_count LOOP dbchange4
4845: UPDATE mtl_serial_numbers
4846: SET group_mark_id = NULL, line_mark_id = NULL, lot_line_mark_id = NULL
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

Line 4864: DELETE FROM mtl_serial_numbers_temp

4860:
4861: --FORALL i IN 1 ..l_tbl_count
4862:
4863: FORALL i IN l_delMMTTtempid.FIRST ..l_delMMTTtempid.LAST
4864: DELETE FROM mtl_serial_numbers_temp
4865: WHERE l_delMMTTserialctrl(i) IN (2, 5)
4866: AND ((l_delMMTTlotctrl(i) <> 2
4867: AND transaction_temp_id = l_delMMTTtempid(i))
4868: OR (l_delMMTTlotctrl(i) = 2