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.INV_SERIAL_EO_PVT dependencies on MTL_SERIAL_NUMBERS

Line 42: from mtl_serial_numbers

38:
39: BEGIN
40: select serial_number
41: into l_serial_number
42: from mtl_serial_numbers
43: where current_organization_id = p_organization_id
44: and inventory_item_id = p_inventory_item_id
45: and serial_number = p_from_serial_number;
46: -- this is an existing serial, nothing to do

Line 175: delete from mtl_serial_numbers

171: )
172: IS
173: BEGIN
174:
175: delete from mtl_serial_numbers
176: where current_organization_id = p_organization_id
177: and inventory_item_id = p_inventory_item_id
178: and serial_number between p_from_serial_number and p_to_serial_number;
179:

Line 712: update mtl_serial_numbers

708: mydebug('After calling validate_update_serial_att');
709:
710: -- update the DFF
711: mydebug('update_attributes');
712: update mtl_serial_numbers
713: set attribute1= ddp_attributes_tbl(1)
714: , attribute2= ddp_attributes_tbl(2)
715: , attribute3= ddp_attributes_tbl(3)
716: , attribute4= ddp_attributes_tbl(4)