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

Line 646: from mtl_serial_numbers

642: if (p_active_end_date is not null or p_active_end_date <> fnd_api.g_miss_date) then
643: begin
644: select current_status
645: into l_old_current_status
646: from mtl_serial_numbers
647: where inventory_item_id = l_inventory_item_id
648: and serial_number = l_serial_number
649: and rownum <= 1;
650:

Line 1100: from mtl_serial_numbers

1096: if (p_equipment_object_id is not null and p_equipment_object_id <> fnd_api.g_miss_num) then
1097: begin
1098: select current_organization_id, inventory_item_id, serial_number
1099: into l_prod_organization_id, l_prod_inventory_item_id, l_prod_serial_number
1100: from mtl_serial_numbers
1101: where gen_object_id = p_equipment_object_id;
1102: exception
1103: when others then
1104: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 1163: from mtl_serial_numbers

1159:
1160: -- Check that the equipment serial number belongs to the
1161: -- equipment item
1162: select count(*) into l_count
1163: from mtl_serial_numbers
1164: where inventory_item_id = l_prod_inventory_item_id
1165: and current_organization_id = l_prod_organization_id
1166: and serial_number = l_prod_serial_number;
1167: