APPS.INV_WIP_PICKING_PVT dependencies on MTL_SYSTEM_ITEMS

Line 898: FROM mtl_system_items

894:
895: BEGIN
896: SELECT revision_qty_control_code, lot_control_code
897: INTO l_revision_control_code, l_lot_control_code
898: FROM mtl_system_items
899: WHERE organization_id = l_organization_id
900: AND inventory_item_id = l_mo_line.inventory_item_id;
901: EXCEPTION
902: WHEN NO_DATA_FOUND THEN

Line 1502: FROM mtl_system_items

1498: l_mol_allocation_status := g_completely_allocated;
1499: END IF;
1500: -- Calculate the quantity detailed in the UOM of the move order line
1501: SELECT primary_uom_code INTO l_primary_uom
1502: FROM mtl_system_items
1503: WHERE organization_id = p_mo_line_rec.organization_id
1504: AND inventory_item_id = p_mo_line_rec.inventory_item_id;
1505:
1506: IF (l_primary_uom <> p_mo_line_rec.uom_code) THEN