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 MTL_SYSTEM_ITEMS

Line 209: FROM mtl_system_items

205: SELECT serial_number_control_code
206: , eam_item_type
207: INTO l_serial_control_code
208: , eam_item
209: FROM mtl_system_items
210: WHERE inventory_item_id = p_inventory_item_id
211: AND organization_id = p_organization_id;
212:
213: IF (l_serial_control_code = 1) THEN

Line 472: FROM mtl_system_items

468: /**ELSE**/
469: BEGIN
470: SELECT serial_number_control_code
471: INTO l_serial_control_code
472: FROM mtl_system_items
473: WHERE inventory_item_id = p_inventory_item_id
474: AND organization_id = p_organization_id;
475:
476: -- invtrace('serial_number_control_code is ' || l_serial_control_code);

Line 877: -- specified in the mtl_system_items

873: g_serial_attributes_tbl(1).column_value := NULL;
874: END IF;
875:
876: -- if the p_status_id is null, then default the status if it is
877: -- specified in the mtl_system_items
878: -- invtrace('p_status_id is ' || p_status_id);
879: IF p_status_id IS NULL THEN
880: -- invtrace('p_status_id is null. calling inv_material_status_grp.get_lot_serial_status_control');
881: inv_material_status_grp.get_lot_serial_status_control(