APPS.EAM_ASSET_ROUTES_PUB dependencies on MTL_SERIAL_NUMBERS

Line 71: FROM mtl_system_items MSI , mtl_serial_numbers MSN

67: BEGIN
68: IF (p_maintenance_object_type = 1) THEN
69: IF ( p_asset_number IS NOT NULL ) THEN
70: SELECT count(*) INTO l_count_rec
71: FROM mtl_system_items MSI , mtl_serial_numbers MSN
72: WHERE MSN.serial_number = p_asset_number
73: AND MSN.gen_object_id = p_maintenance_object_id
74: AND MSN.inventory_item_id = MSI.inventory_item_id
75: AND MSI.inventory_item_id = p_asset_group_id

Line 128: mtl_serial_numbers msn,

124: IS
125: SELECT
126: msn.gen_object_id
127: FROM
128: mtl_serial_numbers msn,
129: mtl_system_items_b msi
130: WHERE
131: msn.inventory_item_id = p_inventory_item_id and
132: msn.serial_number= p_serial_number and

Line 180: select network_asset_flag into l_asset_route from mtl_serial_numbers where gen_object_id = p_object_id;

176: p_error_msg in VARCHAR2)
177: is
178: l_asset_route varchar2(1);
179: BEGIN
180: select network_asset_flag into l_asset_route from mtl_serial_numbers where gen_object_id = p_object_id;
181: IF (p_asset_route <> nvl(l_asset_route,'N')) then
182: raise_error(p_error_msg);
183: END IF;
184: EXCEPTION