APPS.EAM_MATERIALISSUE_PVT dependencies on MTL_PARAMETERS

Line 297: from mtl_parameters

293:
294:
295: select NEGATIVE_INV_RECEIPT_CODE
296: into l_neg_inv_receipt_code
297: from mtl_parameters
298: where organization_id = p_organization_id;
299:
300: IF l_neg_inv_receipt_code = 2 THEN
301:

Line 544: from mtl_system_items_b_kfv msi, mtl_parameters mp

540: begin
541: l_rebuild_item_id := nvl(p_rebuild_item_id,l_rebuild_item_id_wl); --changed for bug 8661513
542: if (nvl(p_rebuild_item_id,l_rebuild_item_id_wl) is null) then --changed for bug 8661513
543: select msi.inventory_item_id into l_rebuild_item_id
544: from mtl_system_items_b_kfv msi, mtl_parameters mp
545: where concatenated_segments = p_rebuild_item_name
546: and msi.organization_id = mp.organization_id
547: and mp.maint_organization_id = p_organization_id
548: and eam_item_type = 3 --3 for rebuild