APPS.EAM_REBUILDS_PVT dependencies on MTL_SYSTEM_ITEMS_B

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 191: from mtl_system_items_b_kfv

187:
188: begin
189: if (p_rebuild_activity_id is not null) then
190: select inventory_item_id into l_dummy_num
191: from mtl_system_items_b_kfv
192: where inventory_item_id = p_rebuild_activity_id
193: and organization_id = p_organization_id
194: and eam_item_type = 2;
195: elsif (p_rebuild_activity_name is not null) then

Line 197: from mtl_system_items_b_kfv

193: and organization_id = p_organization_id
194: and eam_item_type = 2;
195: elsif (p_rebuild_activity_name is not null) then
196: select inventory_item_id into p_rebuild_activity_id
197: from mtl_system_items_b_kfv
198: where concatenated_segments = p_rebuild_activity_name
199: and organization_id = p_organization_id
200: and eam_item_type = 2;
201: if (l_log and (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) then