APPS.EAM_REBUILDS_PVT dependencies on MTL_PARAMETERS

Line 69: from mtl_system_items_b msi, mtl_parameters mp

65: begin
66: if (p_rebuild_item_id is not null) then
67: select inventory_item_id, serial_number_control_code
68: into l_dummy_num, l_serial_control_code
69: from mtl_system_items_b msi, mtl_parameters mp
70: where msi.inventory_item_id = p_rebuild_item_id
71: and msi.organization_id = mp.organization_id
72: and mp.maint_organization_id = p_organization_id
73: and eam_item_type = 3

Line 78: from mtl_system_items_b_kfv msi, mtl_parameters mp

74: and rownum = 1;
75: elsif (p_rebuild_item_name is not null) then
76: select inventory_item_id, serial_number_control_code
77: into p_rebuild_item_id, l_serial_control_code
78: from mtl_system_items_b_kfv msi, mtl_parameters mp
79: where msi.concatenated_segments = p_rebuild_item_name
80: and msi.organization_id = mp.organization_id
81: and mp.maint_organization_id = p_organization_id
82: and eam_item_type = 3

Line 116: from mtl_serial_numbers msn, mtl_parameters mp

112: end if;
113: begin
114: select serial_number, current_status, gen_object_id, current_organization_id
115: into l_dummy_char, l_current_status, l_object_id, l_cur_organization_id
116: from mtl_serial_numbers msn, mtl_parameters mp
117: where inventory_item_id = p_rebuild_item_id
118: and current_organization_id = mp.organization_id
119: and mp.maint_organization_id = p_organization_id
120: and serial_number = p_rebuild_serial_number;