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_NUMBER_PUB dependencies on DUAL

Line 278: FROM DUAL;

274: END;
275:
276: SELECT mtl_gen_object_id_s.NEXTVAL
277: INTO x_object_id
278: FROM DUAL;
279:
280: l_userid := fnd_global.user_id;
281: l_loginid := fnd_global.login_id;
282: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, p_serial_number, x_msg_data);

Line 527: FROM DUAL;

523: END;
524:
525: SELECT mtl_gen_object_id_s.NEXTVAL
526: INTO x_object_id
527: FROM DUAL;
528:
529: -- invtrace('next genealogy object id from the sequence mtl_gen_object_id_s is ' || x_object_id);
530: l_wms_installed :=
531: wms_install.check_install(

Line 1510: FROM DUAL;

1506: isunique := is_serial_unique(p_organization_id, p_inventory_item_id, l_cur_serial_number, x_msg_data);
1507: IF (isunique = 0) THEN
1508: SELECT mtl_gen_object_id_s.NEXTVAL
1509: INTO x_object_id
1510: FROM DUAL;
1511:
1512: INSERT INTO mtl_serial_numbers
1513: (
1514: inventory_item_id

Line 6593: FROM DUAL

6589: BEGIN
6590: IF p_template_id IS NOT NULL THEN
6591: BEGIN
6592: SELECT 2 INTO l_exists
6593: FROM DUAL
6594: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments
6595: WHERE NVL(organization_id,-1) = NVL(p_organization_id,-1)
6596: AND template_id = p_template_id
6597: );

Line 6607: FROM DUAL

6603: NULL;
6604: ELSE
6605: BEGIN
6606: SELECT 2 INTO l_exists
6607: FROM DUAL
6608: WHERE EXISTS (SELECT 1 FROM mtl_serial_tagging_assignments
6609: WHERE organization_id = p_organization_id
6610: AND inventory_item_id = p_inventory_item_id
6611: );